ACCESS PASSWORD

[echan]

IF I use full version of Access for the database backend for a distributed application (eg. VB proj), can I set up a password so that the user cannot open the database in design mode? Can someone provide the code in VB?

 

[MatsHulten]

If I were you I'd set up this from inside Access and not go about messing around in VB-code.
But then again, it can be done. Set a referense to ADOX and create a collection object to point to your DB. Then create a user object for the administration of user permissions.

I'm sorry if I'm a bit vague, but this is as yet only theory for me. It would be interesting to see your solution if you decide to continue, and I'd be happy to continue provide input.

Good Luck
-Mats Hulten

 

[echan]

I found that you can set a password for a database (*.mdb) and then use DBENGINE in Vb to input the password and get a database reference object. However, if i try to open the database as an application (that is use an access application object), there is no code for inputting the password and the user will be prompted for a pswd when the access window opens...is there a way to input the password in code?

 

[MatsHulten]

I honestly don't know. But then again, why open the DB as an application? Why not go via ADO and send the username and password in the connectionstring as usual?

-Mats