Solved

Microsoft Query on Replicable Access database

Posted on 2009-05-03
3
289 Views
Last Modified: 2013-11-27
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
Comment
Question by:StevenPMoffat
  • 2
3 Comments
 
LVL 30

Expert Comment

by:hnasr
ID: 24301729
Try to reproduce the issue using few objects (Excel document, small access database), zip and attach here
0
 

Author Comment

by:StevenPMoffat
ID: 24321263
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
 

Accepted Solution

by:
StevenPMoffat earned 0 total points
ID: 24407668
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 Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

856 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question