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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-08-01 : 12:37:28
|
| Ron writes "I am trying to set up a linked server to be able to see tables in an Access DB. I have done everything MS says to do. I have even copied and pasted code meant to access the Northwind DB, but I still get the error message: Error 7399: OLE DB provider ‘Microsoft Jet.OLEDB.4.0’ reported an error.I looked up error 7399 on MS, which says it is a password issue, i.e. you must use Admin, which I tried, but still got the same error message. Again I copied code, which included the proper security settings, tried every option possible, but can't past the error. I am using Access 2002, when I looked at the engine version, it says Jet ver. 4.Any clues?Ron" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-01 : 12:38:50
|
| Take a look here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=17719The same thing that happens with Oracle happened to me using Access linked servers. Make sure to provide a full connection string for provider and product and see if it works. |
 |
|
|
|
|
|
Linked Server