
December 15th, 2003, 10:48 AM
|
|
Junior Member
|
|
Join Date: Feb 2003
Posts: 4
Time spent in forums: < 1 sec
Reputation Power: 0
|
|
|
MS Access Project (.adp) and SQL server 2000
Hello.
I would like any advice on connecting an Access project to sql server 2000.
I can connect a standard Access db to the server and link the tables etc. However, when I try to connect an Access project to it, I get error 18456 - login failed for user "<username>"
I have checked the server properties in enterprise manager and made sure the authentication is in mixed mode. I have given the user I am trying to connect with, every permission that I can find, on every db.
Still no joy.
Can anyone help?
An Access project seems like a good gui for an sql server app. I wish to develop.
|