couple of things - which version of ACCESS - are you linking to a SQL Server or using a .mdb database?
Can you post your query so we can see exactly what you're doing? Eg
select * from orders inner join customers on orders.customerid = customers.id and also post the exact error message?
I hope that when I die someone will say of me "That guy sure owed me a lot of money"