Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need consistent path name for Excel--Access query; Excel keepschanging it
I have spreadsheets that pull from Access for PivotTable information.
The database resides on a shared drive; the spreadsheets are on a SharePoint. I've set them to automatically refresh. The problem is, I want the path to the share drive to be \\share\drive \directory\database.mdb. Excel keeps changing it back to A:\\directory \database.mdb. Although that path *happens* to work when I have the drive mapped as A:\\, other people are going to have it mapped to different letters. What can I do to force Excel to use a consistent naming scheme? The part of the query that contains the path to the Access database is in Edit Query -- Connection. If there is somewhere else I need to be changing it, please let me know. Deleting my existing queries and starting from scratch with \\share\drive didn't work; it automatically made the path be A:\\. Provider=Microsoft.Jet.OLEDB.4.0;Password="";User ID=Admin;Data Source=<<this is where I'm changing it;Mode=Share Deny Write;Extended Properties="";Jet OLEDB:System database="";Jet OLEDB:Registry Path="";Jet OLEDB:Database Password="";Jet OLEDB:Engine Type=5;Jet OLEDB:Database Locking Mode=0;Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Global Bulk Transactions=1;Jet OLEDB:New Database Password="";Jet OLEDB:Create System Database=False;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;Jet OLEDB:SFP=False |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need consistent path name for Excel--Access query; Excel keepschanging it
I have the same problem. Any solutions out there?
Thanks H |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you change linked Excel file to Access path with Excel VBA | Excel Programming | |||
Excel 2k3 query path to current directory | Excel Discussion (Misc queries) | |||
setting a dynamic path in an excel query | Excel Programming | |||
Having trouble with web query, importing not consistent. | Excel Discussion (Misc queries) | |||
How to use a Access Query that as a parameter into Excel database query | Excel Discussion (Misc queries) |