Passing a Password

[icemanmt78]

I am having major probs trying to pass a password to an access database.

The code is below:

Set Mark = OpenDatabase("C:\windows\desktop\mark.mdb", , False, "mufc")

The password for the database is mufc ( in lower case )
As far as i know i am passing the password in the correct syntax but i still keep on getting the error message

RTE 3031 Not a valid password

WHY!!!!!!!!!

If I then try and open the database exclusivly and pass the password ( see code below ) I get a new error message:

RTE 3170 Can't find installable ISAM ( WHAT????)

Set Mark = OpenDatabase("C:\windows\desktop\mark.mdb", True, False, "mufc")

I need help as this project needs to be finished by mon afternoon.

Anything will help.

Regards

Mark

[Ianpbaker]

Hi icemanmt78

Try replacing the following

Set Mark = OpenDatabase("C:\windows\desktop\mark.mdb", , False, "mufc")

With

Set Mark = OpenDatabase("C:\windows\desktop\mark.mdb", , False, "PWD=mufc")

I think this will sort out your problem but I haven't used DAO for quite some time.

Ian

[icemanmt78]

That still gives me the same error message

[Ianpbaker]

Is there a username to accompany this password for the database ?

Ian

[icemanmt78]

I am working on a standard access 97 database with standard security. I don't have any users. I am not sure what you mean by users regarding an access database.

I am still stuck