Server: Win Server 2003 R2 standard x64
MSSQL: Server 2005 Standard x64
Using SSMS on the database server itself I can execute a simple select on a linked server with OPENQUERY and I can also execute an OPENROWSET with the equivalent UNC path. The file in question is an Access database on a remote server.
However, when I attempt to use the same queries from a remote server or through a remotely executed stored procedure I receive the following error:
"The Microsoft Access database engine cannot open or write to the file '\\[xxx.xxx.xxx.xxx\path\blah\AccessData.mdb'. It is already opened exclusively by another user, or you need permission to view and write its data.".
It seems like it's a permissions issue, but the same credentials that work when executing from the database server do not work from another server. The file definitely isn't open by anyone else.
I'm at my wits end and any help would be greatly appreciated.