connect to password protected access db

Expand Post »

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

Similar Threads

I bought a computer from a school auction.It is password protected.is there anything in Windows NT / 2000 / XP
Accessing Password Protected Zip File Contents with VB.net in VB.NET
Run a cronjob where the file is inside a password protected directory in PHP
Connecting password protected MS Access database from C# in C#
Connecting VB with password protected ms access using adodc in Visual Basic 4 / 5 / 6

tomex

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

1 posts
since Sep 2003

Permalink

Oct 4th, 2003

Re: connect to password protected access db

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

phickman7872

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

6 posts
since Oct 2003

Permalink

Feb 15th, 2005

Re: connect to password protected access db

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

dimuthubas

Reputation Points: 10

Solved Threads: 1

Newbie Poster

Offline

4 posts
since Feb 2005

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Timer Question

Next Thread in Visual Basic 4 / 5 / 6 Forum Timeline: Displaying QBasic Object Code

DaniWeb Message

Cancel Changes

User Name
Password