Microsoft Query on Replicable Access database

I am trying to start Microsoft Query from Excel and connect to an Access 2003 database that is a master replica, but I kept getting a fatal error message "Mircosoft Query has encountered a problem and needs to close."
If I try the same steps but use a non-replica version of the database, it works OK.  Does anybody know if this is a constraint of Microsoft Query and why?
StevenPMoffatAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
StevenPMoffatConnect With a Mentor Author Commented:
In trying to build a simple database, I rebuilt the database and made it a new Master replica and no longer had the problem.
0
 
hnasrCommented:
Try to reproduce the issue using few objects (Excel document, small access database), zip and attach here
0
 
StevenPMoffatAuthor Commented:
Standby.  I tried a simple database and it worked.  I now need to parse down the complex master replica and see if I can get to a simpler structure that is broken.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.