Having an issue BUT cannot figure out why. (actually 2 issues)
1. Have Access 2003 linked to SQL 2005 tables.
Primary Key in 1 is a uniqueidentifier data type and child in second is the same.
This is true on several tables.
Some link OK and some do not using this link
BUT Problem only occurs in Access.
If I do query in SQL then it works ok.
If I do it in Access I get NO return rows UNLESS query uses Outer Join with Child Link ID field set to NOT NULL.
2. Other issue I have is retrieving the UniqueIdentifier value in VBA to a variable.
Although the value exist ok it returns ?????? to the variable NOT the correct ID
Does this if I use variant, or String and error with Long.
Sometimes I need this value so how can I get it?
Any answers to either of these questions would save me a lot of aggravation and stress.
Over to you guys.