-
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
-
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
-
Still doesnt work
That still gives me the same error message
-
Is there a username to accompany this password for the database ?
Ian
-
No
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
