Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Dance Doll
Yak Posting Veteran
54 Posts |
 Posted - 2006-12-18 : 16:55:24
|
| Hi, thereI wrote a OpenRowset query in SQL Server 2000 to access my 2003 Access DB:select *from OpenRowset ('microsoft.jet.oledb.4.0', 'G:\myFolder\myDB.mdb';'myname';'myPWD','myTable')I got error: "Server: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'microsoft.jet.oledb.4.0' reported an error. Authentication failed.[OLE/DB provider returned message: Cannot start your application. The workgroup information file is missing or opened exclusively by another user.]OLE DB error trace [OLE/DB Provider 'microsoft.jet.oledb.4.0' IDBInitialize::Initialize returned 0x80040e4d: Authentication failed.]."The Access DB is password protected and My login was added to the work group. When I open Access DB directly, it would asked me work group login name & password. Then it asked DB password.I know something tricky here about work group and password. How to solve this problem by using OpenRowset query?Thanks! |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2006-12-19 : 00:59:41
|
| Make sure "g:\..." path is realtive to the sql server.Also take a look at www.connectionstrings.com for propert setup with username/password in the connectionstring for MS ACCESS.Peter LarssonHelsingborg, Sweden |
 |
|
|
|
|
|
OpenRowset