If anyone can help with a problem linking across to a table in a database on a SQL 2000 server, then please visit Linking from Access over in SQL Server.
I'm locking this so that any and all responses are kept in the one thread.
2 results in 0.0038 seconds.
-
Linking from Access
My setup
I have a SQL Server (2000) back end database, which I access via Access (among other methods). I use an ODBC link and Windows authentication. As an administrator I am mapped onto sa level access. I have full rights to manage everything via this link.
My SQL Server is available across the LAN (100Mbps link), and for the most part appears to be behaving as expected. It runs on a two processor (2 chips) server...