Excel Msqry error when import from Access db on network

  • Thread starter Thread starter Becky LeBlanc
  • Start date Start date
B

Becky LeBlanc

From Excel, get external data, new db query, when I select
a particular Access db on the network, I get the following
error "MsQuery has encountered a problem and needs to
close". If I copy the db to the harddrive, I do not get
the error. From the network, I've removed all internal
linked tables and basically stripped the db down but still
get the error. Network folks assure me this is not a
network security problem. I've also tried changing options
and properties on the db and still can't get this to work.
Any advise would be appreciated. thanks.
 
Have you tried the option "compact and repair"?

Make a copy of the DB (for backup)
Close the DB (NOT Access), "Options", "Database
Utilities", "Compact and repair DB".

JohnQ
 
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

Corrupted DB 1
Access Access 2010 Backend DB Backup/Restore 0
import in Access 2007 9
Q.) Jet DB error: Multiple Users able to write to MS Access DBsimutaneously? 3
Merge 2 Db's 3
Linking external db into table 3
Problem with access acImportDelim importing csv with headers 1
Using Access to create reports of a FileMaker Pro DB 1

Back
Top