I am running MSDE as the server.
I created a Microsoft Access Project and connected to the MSDE. Security is
set to Integrated Security.
When I try to open the database from an application I am writing I get a
login error stating the user doesn't have rights to the database. I am
logged in to the computer with administrator privledges but get the error.
I know that I have to tell the server that users have access to the database
but how do I do that if I can't gain access to the database?
Thanks,
EricI have hit this problem with sql server as well. I fixed it by
creating a server based login. that is one that requires a user name
and password. That way in the program all you need for permission is
those to fields in teh Connection String. Of course you still need to
grant that login access to the relevent dbs
No comments:
Post a Comment