OpenDatabase with password

A

A. Pach

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
 
A

A. Pach

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.
 
I

IM

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,
 
M

mmagnes

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
how to open an mdb file has a database password form another mdb 1
>> dao connect with password 4
Enabling Allowbypasskey with DB that has a password 1
OpenDatabase help please? 2
Unable to update/add records in connected SQL Server tables 4
Relink to tables with password on BE 4
Link BE with codes 3

Top