Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
saltzmanjoelh
Starting Member
10 Posts |
Posted - 2007-09-26 : 20:31:41
|
I am trying to link my ORDERS table to my CUSTOMERS table.The Primary key in the CUSTOMERS table is a UNIQUEIDENT.The foreign key it is linking to is an INT.When I run a query in ACCESS, it says type mismatch....Any solutions? |
|
rrb
SQLTeam Poet Laureate
1479 Posts |
Posted - 2007-09-26 : 21:39:08
|
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" |
|
|
|
|
|