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 |
|
burwelj
Starting Member
4 Posts |
 Posted - 2008-01-15 : 14:11:01
|
| I'm trying to set up a linked table from SQL Server 2005 to MS Access. The .mdb file resides on a network share and I'm unable to connect to it. If i copy the database to a folder on the server that SQL is installed, it works fine. Any help would be greatly appreciated. Below is the error message that I'm receiving.TITLE: Microsoft SQL Server Management Studio------------------------------"The linked server has been created but failed a connection test. Do you want to keep the linked server?"------------------------------ADDITIONAL INFORMATION:An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)------------------------------Cannot initialize the data source object of OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LINKSERVER".OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "LINKSERVER" returned message "The Microsoft Jet database engine cannot open the file '\\server\share\database.mdb'. It is already opened exclusively by another user, or you need permission to view its data.". (Microsoft SQL Server, Error: 7303) |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-01-15 : 23:18:19
|
| Did you check mdac version on remote server? |
 |
|
|
Paulus
Starting Member
1 Post |
Posted - 2008-01-28 : 09:03:31
|
| The Access database file must reside on the server. The path must be valid on the server.Try mapping a drive to \\server\share\database.mdb. |
|
|
|
raju1973
Starting Member
1 Post |
Posted - 2010-03-03 : 06:41:42
|
| hi burwelj, if the above issue was solved please let me know since I have exactly the same problem |
|
|
|
|
|
|
Linked table from SQL 2005 to Access error...