DaniWeb Forum Index > Software Development > Visual Basic 4 / 5 / 6

Visual Basic 4 / 5 / 6 RSS

connect to password protected access db

•

Join Date: Sep 2003

Posts: 1

Reputation: tomex is an unknown quantity at this point

Solved Threads: 0

tomex

Offline

Newbie Poster

connect to password protected access db

Sep 27th, 2003

hi every
am anew guy in all this stuf
however i want to connect to an access 97 data base with a password
through visual basic 6 however each time i try to connect it give me an error
i put in the correct username and password

can some one help me on how i can connect to this please

Tomex

•

Join Date: Oct 2003

Posts: 6

Reputation: phickman7872 is an unknown quantity at this point

Solved Threads: 0

phickman7872 phickman7872 is offline

Offline

Newbie Poster

Re: connect to password protected access db

Oct 4th, 2003

Hi tomex,

A couple of questions:

1) Are you using ADO or DAO to connect to this database?

2) What string are using to connect to the database.

Also, some very excellent code on this subject may be found at http://www.freevbcode.com

•

Join Date: Feb 2005

Posts: 4

Reputation: dimuthubas is an unknown quantity at this point

Solved Threads: 1

dimuthubas dimuthubas is offline

Offline

Newbie Poster

Re: connect to password protected access db

Feb 15th, 2005

Try This ..

Dim DB As Database

Set DB = OpenDatabase("\\Server1\GST\Payroll\PayrollDB.mdb", False, False, ";PWD=IIT")

Here "\\Server1\GST\Payroll\PayrollDB.mdb" is the DB location..

and under project referance u should select "Microsoft DAO 2.5/3.0 compatible Library"

Cheers
Bass