Updating query in peer-to-peer network

  • Thread starter Thread starter mrclinker
  • Start date Start date
M

mrclinker

Dear experts:

In computer A, I have an Access database and a Microsoft Query in
Excel that queries this database. The query works fine and updates the
information.

The problem is that when I access the Excel file through the network
from computer B and try to update the query I get an error message
saying that the database path could not be found. (I think this is
logical because the Access database is in computer A).

How can I fix this in order to update the query directly from computer
B?

Thank you very much,

MrClinker.
 
I mean:

The exact message is:

[Microsoft][Microsoft Access ODBC Driver] Could not open the file 'the
database path in computer A'

How can I change the database path in Microsoft Query, without re-
writing the query? It seems that the database path is hardcoded
somewhere in the query. If I can do this I will have to copy all the
queries to computer B and change the database path...

Thanks again.

MrClinker
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Peer to peer 2
Access over a peer to peer network 4
xp peers to peer networks 10
Hyperlinks on peer to peer network 2
Linked Excel File won't update 1
Peer-to-peer/Access problem 1
Counting multiple memberships 1
Am I disturbing a machine in production floor if I access its database remotely? 4

Back
Top