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

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

Msg 18456

I am getting error message on login as follows:
K:\>isql -U BSCI\ziegelmd
Password:
Msg 18456, Level 14, State 1:
Login failed for user 'BSCI\ziegelmd'.
DB-Library: Login incorrect.
I can login using isqlw, and the test connection via Visual Studio 2003
works. The security is set up for SQL Server and Windows. Starts in system
account. User BSCI\ziegelmd is set up for the master database. I am using
the same password as Windows domain logon. Everything is on XP professional
OS. This problem is stopping me dead in my tracks. Any suggestions would be
highly appreciated.ISQL -E
The -E indicates trusted connection and will use the currently logged on
user's NT credentials.
--
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"dziegel" wrote:
> I am getting error message on login as follows:
> K:\>isql -U BSCI\ziegelmd
> Password:
> Msg 18456, Level 14, State 1:
> Login failed for user 'BSCI\ziegelmd'.
> DB-Library: Login incorrect.
> I can login using isqlw, and the test connection via Visual Studio 2003
> works. The security is set up for SQL Server and Windows. Starts in system
> account. User BSCI\ziegelmd is set up for the master database. I am using
> the same password as Windows domain logon. Everything is on XP professional
> OS. This problem is stopping me dead in my tracks. Any suggestions would be
> highly appreciated.
>