LarryDavidow
Technical User
Please help!!
I recently had to do an XP repair on my OS and took the liberty of installing Windows XP SP1.
I am having a problem connecting to SQL server with my Access Data Projects. When I create the connection and test it, it tests fine, however, it opens up as disconnected. There are no tables, views or SP's in the window. In Excel, I can import external data from SQL, and the data comes in just fine.
When I go to File->Connection in access, it confirms the connection, but then still can't connect. I've tried setting the authentication from Trusted to Specified, but still no joy.
Any ideas would be much appreciated.
Environment:
Windows XP running SP1. Office XP running Access 2002.
I recently had to do an XP repair on my OS and took the liberty of installing Windows XP SP1.
I am having a problem connecting to SQL server with my Access Data Projects. When I create the connection and test it, it tests fine, however, it opens up as disconnected. There are no tables, views or SP's in the window. In Excel, I can import external data from SQL, and the data comes in just fine.
When I go to File->Connection in access, it confirms the connection, but then still can't connect. I've tried setting the authentication from Trusted to Specified, but still no joy.
Any ideas would be much appreciated.
Environment:
Windows XP running SP1. Office XP running Access 2002.
