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 - 2003-05-15 : 07:20:29
|
| Mijo writes "Dear Sir,I have a problem with Linked server. I am trying to make Linked server with Access database but I am encountring following error when I logged on SQL server with 'sa' login and write following SQL statement.SELECT * FROM AGAM...LocationServer: Msg 7399, Level 16, State 1, Line 1OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: The Microsoft Jet database engine cannot open the file '\\AGAM\UNICEF\UNICEF.mdb'. It is already opened exclusively by another user, or you need permission to view its data.]where AGAM is the name of server where the UNICEF.mdb database exists.Please help me ...............Mijo"Edited by - merkin on 05/15/2003 11:17:30 |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2003-05-15 : 10:49:41
|
| What method of security, if any, does the access database employe? Database password, work group file (*.mdw or *.mda), or nothing.If it's nothing, then is the database opened by somepne else?Brett8-) |
 |
|
|
Mijo
Starting Member
1 Post |
Posted - 2003-05-20 : 00:40:56
|
| I added Access server like this. .........................................step 1...........EXEC sp_addlinkedserver @server = 'AGAM', @provider = 'Microsoft.Jet.OLEDB.4.0', @srvproduct = 'OLE DB Provider for Jet',@datasrc = '\\AGAM\UNICEF\UNICEF.mdb'GOstep 2.................EXEC sp_addlinkedsrvlogin 'AGAM', 'false', 'sa', 'Admin', NULL.......................where Admin is the default user name with Null password resides in server name AGAM.I am previous problem. Plz help me soon................... Mijo Sinji UtabaYokohama ,Japan |
|
|
|
|
|
|
|
|
The post with no title