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.

All Forums  SQL Server 2000 Forums  SQL Server Administration (2000)  Linked Access Server

Author  Topic  John Starting Member 9 Posts Posted - 2001-04-06 : 04:45:33 I have successfully created a linked Access 2000 server on MSDE on my Win2000 workstation. However, when I try to do the same on the main server which hosts SQL7 (setting the reg to point to the relevant Access password file) all I get when I try to run the OpenRowSet query is: Server: Msg 7399, Level 16, State 1, Line 1 OLE DB provider 'Microsoft.Jet.OLEDB.4.0' reported an error. [OLE/DB provider returned message: The Microsoft Jet database engine cannot open the file ''. It is already opened exclusively by another user, or you need permission to view its data.] Can anyone shed any light on this?