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

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????

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/de...eDatabaseS.asp
and:
http://support.microsoft.com/default...t%2Fsecfaq.asp
--
- K Dales


"amrezzat" wrote:

>
> 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????
>
>
> --
> amrezzat
> ------------------------------------------------------------------------
> amrezzat's Profile: http://www.excelforum.com/member.php...o&userid=28766
> View this thread: http://www.excelforum.com/showthread...hreadid=538893
>
>

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

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...1&d=1146831711