Link to home
Start Free TrialLog in
Avatar of rafox
rafox

asked on

data control ACCESS passwords

Is there a way to enter an ACCESS database password in a data control object on a VB form?  If so, how do I do it? It seems like there should be a simple way to put it in the properties someplace but I can't find it. I'm using ACCESS 97 and VB 5.0.   --BOB
ASKER CERTIFIED SOLUTION
Avatar of MikeP090797
MikeP090797

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rafox
rafox

ASKER

Connect gives me a selection of database type.  Access is already selected.  Do I add your solution to Access to give me 'Access;pwd=password' or is there something I'm missing?  When I do this, I get an error 3170 saying 'couldn't find installable ISAM'. The ;pwd=password has always worked well for me with the Set db=OpenDataBase.....("databasename",False,False,";pwd=password").

BOB
For Access database you can ommit the type, just use ";pwd=pass"
Avatar of rafox

ASKER

Thanks, MikeP.  It worked and saved me a lot of re-programming.

BOB