Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Access adp (project file) question

Author  Topic 

Sun Foster
Aged Yak Warrior

515 Posts

Posted - 2006-03-22 : 11:01:42
I used Access project file (.adp) to connect a Windows authentication SQL server, it works fine. At the same adp file, how to cnnect another SQL server but in SQL authentication mode?

timmy
Master Smack Fu Yak Hacker

1242 Posts

Posted - 2006-03-22 : 18:08:32
You're in the wrong forum, but here goes:
In Access, select File --> Connection and it will allow you to enter a username/password in the section marked 'Enter information to log on to the server.
Go to Top of Page
   

- Advertisement -