I'm trying to set up an Excel front end that connects to an Access back end
on a server at work via MSQuery queries (also located on the server). It
works well as long as the server drive is mapped but gives a ODBC Microsoft
Access Driver Login Failed error if it is not mapped. All queries use the UNC
of the server, so it is not a drive letter issue (I've confirmed this by
changing the mapped drive letter and having no letter at all and it works
fine).
The specific error message is "The Microsoft Jet database engine cannot open
the file '\\servername\shared folder\filename.mdb'. It is already opened
exclusively by another user, or you need permission to view its data."
How can I fix this? Do I need to programmatically map the drive for other
users? If so, how? Is there a better way of going about this?
|
