I have an access DB setup that uses linked tables that are linked to a SQL Server. This DB works on all of my PCs in my office except one. The one PC I am having issues with will open only certain tables. But if I open another table first I can open the tables that won't open after. IE I have table A and table B. When I try to open table A I get "ODBC--Connection to 'SQL Server BLAH' failed. But if I open table B I can then open table A.
Even after I open table B, however, if I try to open a form that pulls from multiple tables some of those tables fail with "ODBC - call failed" even though I can go and open up the linked outside of the form.
The user I am logged in has appropriate permissions, infact I tried logging in as Admin and still got the same BS.
The OS is a fresh install of windows 2000 service pack 4. The strange thing is when I first installed it I was having an issue picking up DHCP. It turned out DHCP, which is run on the same server as SQL, was holding a lease with the PC's mac address and it was labeled "BAD Address" so I deleted the lease and it worked fine.
What I am wonder is if somewhere SQL server registers the PCs that connect to its mac addresses?
Even after I open table B, however, if I try to open a form that pulls from multiple tables some of those tables fail with "ODBC - call failed" even though I can go and open up the linked outside of the form.
The user I am logged in has appropriate permissions, infact I tried logging in as Admin and still got the same BS.
The OS is a fresh install of windows 2000 service pack 4. The strange thing is when I first installed it I was having an issue picking up DHCP. It turned out DHCP, which is run on the same server as SQL, was holding a lease with the PC's mac address and it was labeled "BAD Address" so I deleted the lease and it worked fine.
What I am wonder is if somewhere SQL server registers the PCs that connect to its mac addresses?