[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 143
  • Last Modified:

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
0
rafox
Asked:
rafox
  • 2
  • 2
1 Solution
 
MikeP090797Commented:
Use the Connect property ";pwd=pass"
0
 
rafoxAuthor Commented:
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
0
 
MikeP090797Commented:
For Access database you can ommit the type, just use ";pwd=pass"
0
 
rafoxAuthor Commented:
Thanks, MikeP.  It worked and saved me a lot of re-programming.

BOB
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now