Change source of linked database query

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

Does anyone know how to change the source of a linked Access database query?
I need to change the source from the current database to a newly created
database.
 
so, this is a query you've linked from Access to Excel, correct?

you should be able to edit the query by going to Data - Import External Data
- Edit Query...
 

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

Changing Data Links 2
Change the location of external data feeding a pivottable 4
Not all Access queries can be imported 1
Record-Locking remains open after closing 0
External Data Refresh Issues 0
Am I disturbing a machine in production floor if I access its database remotely? 4
Using MS Query with Excel and Access 2007 3
Changing Database links? 3

Back
Top