[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 301
  • Last Modified:

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?
0
StevenPMoffat
Asked:
StevenPMoffat
  • 2
1 Solution
 
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
 
StevenPMoffatAuthor 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

Featured Post

Free Backup Tool for VMware and Hyper-V

Restore full virtual machine or individual guest files from 19 common file systems directly from the backup file. Schedule VM backups with PowerShell scripts. Set desired time, lean back and let the script to notify you via email upon completion.  

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now