Import external database query not working with other users?

[devbox]

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.

 

[Guest]

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

 

[devbox]

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"

 

[Ron Coderre]

Well....I searched Google for your error and got this MS link:

http://support.microsoft.com/kb/q251254/

I hope that helps.

Regards,
Ron

 

[devbox]

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.

 

[devbox]

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! :