Queries and relationships with Linked Tables

[stardust1979]

Hi,



I have created a linked table to a shared Outlook Contacts folder - this has been working fine. However, I now need to create a query based on 2 tables (one a table on my local db and this linked table). I use the access query designer and add the 2 tables and then manually link the two fields, then if I run my query I get "Invalid Argument". If I convert the linked table to a local table the query works. I have also tried to rename the field on my local db to exactly match the field name on my linked table and still get the error.

Has anyone tried this?

Here is my SQL:

SELECT tblCommunication.CommID
FROM tblCommunication INNER JOIN MALTContacts ON tblCommunication.ContactID = MALTContacts.[Customer ID];


NOTE: I stripped the query right back until I solved this problem - it will be more complex eventually once I resolve this linking issue!


I also have seen there is a problem with linked tables when a db gets close to Access's size limit - my db is only 3MB in size.

Any ideas - I have searched around forums and unable to find an answer to this?


Thanks in advance for any help
K

[June7]

I don't see anything 'invalid' about that SQL.

What are the data types of the linking fields - both are text?

[stardust1979]

I don't see anything 'invalid' about that SQL.

What are the data types of the linking fields - both are text?

Yes - they are both text!

[June7]

I did search. Bing: access sql link table query join invalid argument

Perhaps this solution applies to links as well as imports: http://support.microsoft.com/kb/835416

Cause could be from any number of issues. Don't think this one applies but is an example of how varied they can be http://stackoverflow.com/questions/3...access-and-sql