OpenDatabase with password

G

Guest

Hi!

I'm trying to open a .mdb database with a password and i know that I don't
need to use ODBC for this kind of databases. But it seems that this function
is not working:

Set dbs = OpenDatabase("V:\TRM Analytics Team\Databases\Sales
Executives\Headcount.mdb", , , "pwd=123")

Can anyone told me what's wrong with this?

Thanks!

A. Pach
 
G

Guest

Thanks for your response!

I try it but it shows in an ODBC error. Then i try to exclude the first
optional parameter (options) and still giving me a "Not a valid Password"
error and I know is the correct one.

Any other sugesstions...?

A.
 
G

Guest

HI !
you have to pass the optional parameters and the semicolon is missing
try this:

Set dbs = OpenDatabase("V:\TRM Analytics Team\Databases\Sales
Executives\Headcount.mdb", false ,false , ";pwd=123")

NOTE: ";pwd=123"

best regards,
 
G

Guest

A. Pach said:
Hi!

I'm trying to open a .mdb database with a password and i know that I don't
need to use ODBC for this kind of databases. But it seems that this function
is not working:

Set dbs = OpenDatabase("V:\TRM Analytics Team\Databases\Sales
Executives\Headcount.mdb", , , "pwd=123")

Can anyone told me what's wrong with this?

Thanks!

A. Pach
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OpenDatabase with ODBC 1
Enabling Allowbypasskey with DB that has a password 1
>> dao connect with password 4
OpenDatabase help please? 2
Unable to update/add records in connected SQL Server tables 4
Relink to tables with password on BE 4
Can't OpenDatabase using DAO 1
Password not being saved when I create a link to a SQL table 5

Top