?
Solved

Event ID 1000 after Access Replication

Posted on 2004-09-24
9
Medium Priority
?
293 Views
Last Modified: 2010-08-05
I have written a database in Access that needs to replicated between two different machines on my network. As a standalone database it works fine, but as soon as I create a replica, I receive an error message saying "Microsoft Access has encountered a problem and needs to restart...."

The replica seems to work fine, but the Design Master causes this error every time the database opens. The Event Log reports the following:

Type: Error   Source:  Microsoft Office 10   Category:  None   Event ID: 1000
Faulting application msaccess.exe, version 10.0.2616.0, faulting module vbe6.dll, version 6.3.91.8, fault address 0x000533f2.

I'm using Office XP on Windows 2000 SP4. I have tried redoing the replication from the backup, but still the same error. Does any one have any idea why it's doing this?
0
Comment
Question by:Matt_Jones
  • 3
  • 2
  • 2
7 Comments
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12146601
Which Office service pack are you running?
0
 
LVL 66

Accepted Solution

by:
Jim Horn earned 500 total points
ID: 12146653
Here's a thought... If the app sits among users on the same network, and is never disconnected, then you don't need replication, and should get rid of it.  

0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12146693
Jim's made a *very* good point. Why replicate if you don't need to?
0
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

Author Comment

by:Matt_Jones
ID: 12146740
The two PCs have a *very* slow network connection between them and using the DB directly is very painful from the remote computer. The data does not need to be in real time so it can replicate over night to avoid bandwidth issues.
0
 
LVL 66

Expert Comment

by:Jim Horn
ID: 12146840
Sounds like getting them more bandwith would be a better expenditure of money that supporting replication on an Access app, plus whatever else needs to be supported.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
ID: 12146882
Again, which Office XP service pack are you running?
0
 

Author Comment

by:Matt_Jones
ID: 12155458
Sorry - Office XP SP3
0

Featured Post

Restore individual SQL databases with ease

Veeam Explorer for Microsoft SQL Server delivers an easy-to-use, wizard-driven interface for restoring your databases from a backup. No expert SQL background required. Web interface provides a complete view of all available SQL databases to simplify the recovery of lost database

Question has a verified solution.

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

Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Suggested Courses

830 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