Solved

Microsoft Query on Replicable Access database

Posted on 2009-05-03
3
285 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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

706 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now