Thanks for your suggestion. I did 3 other things which solved the problem. I connected to the network drive before connecting to the SQL database,...

Thank you both for your help. I did 3 things which solved the problem. As you suggested, I connected to the network drive first,...

How do I look at the user rights on the server? The server runs Windows 2000 and is not on a domain. The 2...

By forcing connections using named pipes, do you mean removing TCP/IP and leaving only named pipes as a protocol in SQL Server? thnx

Even after I connect to the F: drive, I still can't connect to SQL Server. I assume you mean connecting to F by typing in my username and password?

I will try that, Kathy. Thanks.

The workgroup for all of them seems to be the same (the very original WORKGROUP). Can a user name be different than what it...

I have actually been able to solve this problem. I have opened a recordset object (rst) using a user defined function (returns table) and set the form.recordset=rst in the form.load event. It...

Thank you for your reply. I am somewhat disconcerted to hear that the adp support will vanish. I hope this will not effect this project too much since I have...

Yes, it is an access data project. Thanks again.

Thank you for your help. I believe I have a primary key defined in all of my tables in SQL server as well as...