mssql & msaccess .mdb file with database password

i get daily updated .mdb file from another office.
i have mssql as b/e and msaccess as f/e.
the .mdb file i get daily has a database password,
and i am looking for ways to access the .mdb file through my sql server.
(i want to upload the file to the sql server not having to remove the
password manually daily)
i want to use either
1. use addlinkedserver sp or
2. use openrowset()
can anyone tell me the syntax of either of these in order to supply the
msaccess database password?
TIA.
*** Sent via Developersdex http://www.codecomments.com ***http://www.connectionstrings.com has good examples of many types of
connection strings. It looks like an ODBC connection with an Access
database can be established by using the "Microsoft OLE DB Provider for
ODBC Drivers" with a provider string like this (without the quotes):
"Driver={Microsoft Access Driver
(*.mdb)};Dbq=C:\mydatabase.mdb;Uid=xxx;Pwd=xxx;"
Good luck,
Tony Sebion
"paul a" <paul@.gii.co.jp> wrote in message
news:#mOfQPStFHA.4076@.TK2MSFTNGP11.phx.gbl:

> i get daily updated .mdb file from another office.
> i have mssql as b/e and msaccess as f/e.
> the .mdb file i get daily has a database password,
> and i am looking for ways to access the .mdb file through my sql server.
> (i want to upload the file to the sql server not having to remove the
> password manually daily)
> i want to use either
> 1. use addlinkedserver sp or
> 2. use openrowset()
> can anyone tell me the syntax of either of these in order to supply the
> msaccess database password?
> TIA.
>
> *** Sent via Developersdex http://www.codecomments.com ***