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 Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
ACCESS PASSWORD
- Thread starter echan
- Start date
MatsHulten
Programmer
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
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
- Thread starter
- #3
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
Programmer
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
-Mats
- Status
