I have corruption with my MS Access 2K database so I copied all the objects into a new database. All is well, except I can not link to the MS SQL tables which are on a WIndows 7 machine running MS SQL Server 2008R2 .
The client machine is XP Pro and it is on the same LAN. We have One domain controller on the network but we also have a Windows 2000 server that was recently demoted at a domain controller but still runs Active Directory.
The Domain Controller is a Windows 2003 Server.
Any ideas what's wrong?
If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…