Event ID 1000 after Access Replication

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?
Matt_JonesAsked:
Who is Participating?
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
 
shanesuebsahakarnCommented:
Which Office service pack are you running?
0
 
shanesuebsahakarnCommented:
Jim's made a *very* good point. Why replicate if you don't need to?
0
Cloud Class® Course: Microsoft Exchange Server

The MCTS: Microsoft Exchange Server 2010 certification validates your skills in supporting the maintenance and administration of the Exchange servers in an enterprise environment. Learn everything you need to know with this course.

 
Matt_JonesAuthor Commented:
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
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorCommented:
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
 
shanesuebsahakarnCommented:
Again, which Office XP service pack are you running?
0
 
Matt_JonesAuthor Commented:
Sorry - Office XP SP3
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.