 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / January 2006Import external database query not working with other users?
Help! I set up an import external database query (ms access) for an excel report used on our network that works fine for me, but will not refresh the data for anyone else. It does not appear to be due to any difference in user access or mapping. I set everything up through folders and files that all users have access to. I can't figure out why it only works for me. Is the query set up by the wizzard somehow tied to the user? Thanks, Dave.  Signaturedevbox Did you use a mapped drive in the path to mdb file location? (like K:\MyDatabase.mdb) If yes, then you need to change the mdb file path to the UNC address, something like \\servername\foldername\MyDatabase.mdb Does that help? *********** Regards, Ron XL2002, WinXP-Pro > Help! > [quoted text clipped - 12 lines] > > Dave. Yep, I am using the \\servername\foldername\MyDatabase.mdb path and this works fine for me but it does not refresh for the other users. They get the "[Microsoft][OBDC Microsoft Access Driver] Disk or Network Error" Signaturedevbox Well....I searched Google for your error and got this MS link: http://support.microsoft.com/kb/q251254/ I hope that helps. Regards, Ron SignatureRon Coderre Well, I have found that it is not related just to the user but the computer that I set up the query on. It works fine on whatever computer I set up the query with, but gives me the error above even if I logon and attempt to refresh the data on another system. I have tried the database query, basic import (OLE DB query), and even recorded a macro. They all work fine on whatever system I use to set it up, but produce the above error on other systems. I am using the full path and everything should work. Looks like I am going to have to learn some VBA and try some kind of other code solution. :confused: Signaturedevbox I finally found my problem was really with the path after all. I foun many different ways to import data that I cound get to work because o the path. Now everything works fine. Painfull learning experience! : |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.