Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
connecting to back end server
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). 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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
connecting to back end server
The specific error message that comes up is "The Microsoft Jet database
engine cannot open the file '\\servername\folder\filename.mdb'. It is already opened exclusively by another user, or you need permission to view its data. "bw" wrote: 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). 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I isolate my Excel server (automation) from other Excel instances? | Excel Discussion (Misc queries) | |||
Microsoft][ODBC SQL Server Driver]Syntax error or access violation | Excel Discussion (Misc queries) | |||
Excel 2003 back to Excel 2002 | Excel Discussion (Misc queries) | |||
Outlook 2003 demo back to Outlook XP | Excel Discussion (Misc queries) | |||
Excel 2003 Database Driver Visual FoxPro 7 on Server 2003. | Excel Discussion (Misc queries) |