I am connecting to a SQL server database backend using an Access 2000 frontend. It is working fine on one workstation but on another it keeps asking for a sql server user name and password when you open different forms and it accesses certain tables. I am using the same sql server user name and password on each machine. The only difference I see is that I am logining into Windows (2000 workstation) as a different user on the different workstations. Both Windows users seem to have the same security setting. Any insights?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Access 2000 and SQL Server
- Thread starter diamondsc
- Start date
- Thread starter
- #2
By the way, here is my connection string:
ConnStr = "Provider=sqloledb.1;Driver=SQL Server;Server=" & sqlSvr & ";Database=" & sqlDB & ";UID=" & sqlUser & ";PWD=" & sqlPassword & ";"
sqlSvr, sqlDB, sqlUser, and sqlPassword and string variables set within the application.
ConnStr = "Provider=sqloledb.1;Driver=SQL Server;Server=" & sqlSvr & ";Database=" & sqlDB & ";UID=" & sqlUser & ";PWD=" & sqlPassword & ";"
sqlSvr, sqlDB, sqlUser, and sqlPassword and string variables set within the application.
- Status
Similar threads
- Locked
- Question
