how to link an Access Database from excel if it required a password to open

[amrezzat]

hi guys
i have an open-protected password Access data base how to open it using
DAO

i open any database if there is no passwords
but how can i tell the excel the password to open the database using it
...and iam sure this is the right password????

 

[Guest]

Access user security is a bit of a pain. You not only need to have the user
name and password, you need to be logged into the proper workgroup for the
database. If not logged into the workgroup the external data interface to
Access will connect as if a member of the Users user group (as set up within
the database). So the solutions are to make sure the table(s) you need are
listed in the Users group permissions, or to set up a workgroup file and have
the user who will be running the report log in to the workgroup.

For more info:
http://msdn.microsoft.com/library/d...y/en-us/off2000/html/acdecSecureDatabaseS.asp
and:
http://support.microsoft.com/default.aspx?scid=/support/access/content/secfaq.asp

 

[amrezzat]

hey guys
with the following way i can open an access database which is not
password protected

dbpath = "C:\MistSat\mistdat.mdb"
Set dbnorthwind = OpenDatabase(dbpath)


Dim rseployees As DAO.Recordset
Set rseployees =
dbnorthwind.OpenRecordset("local_operations",dbOpenTable)

but if the file is "password to open" how can i open it??
i should increase one paramater to (opendatabase)
i used the following phrase

Set dbnorthwind = OpenDatabase(dbpath, False, False, "microsft dao 3.6
; pwd=mypwd")
but an error appears "run time error 3170 could not find installable
ISAM"

and when i press debug the previous line is highlighted
so what is wrong?????????
thx in advance

 

[amrezzat]

here is the groups
i think there is only the admin
and i know that password
take a look at the picture attached

http://www.excelforum.com/attachment.php?attachmentid=4730&stc=1&d=114683171

+-------------------------------------------------------------------
|Filename: Image1.jpg
|Download: http://www.excelforum.com/attachment.php?postid=4730
+-------------------------------------------------------------------