Error creating replica

seamusnboo

Registered User.
Local time
Yesterday, 19:56
Joined
Jul 28, 2004
Messages
20
I'm trying to create a replica out of one database I have, but everytime I try to do it I get an error message. What I do is click on Tools, Replications, Create Replica. I do everything as requested. Close the database and make a backup of it. But then when it starts converting it shows the following error message:

"Microsoft Access can't convert the database to a Design Master

Cannot make the MSysAccessObjects object in Tables container replicable"

And then it doesn't create the replica. The weird thing is that I don't have a MSysAccessObjects table.

Does anybody have any idea of what could be wrong?

Thanks
 
Last edited:
-Access has hidden system tables in every database. It sounds like for some reason the replication wizard can't create the system table in the new design master.
-Try compacting & repairing your existing database, and then re-try the replication manager. You may have an error or curruption in one of your tables that is causing a problem
 
As suggested, I tried Compact & Repair, but that still didn't help. The same problem is still happening. Any other ideas of what could be done to fix this?
 
Try creating a new database. This will have its own MSysAccessObjects table. Then import all tables etc. from your original db.
 

Users who are viewing this thread

Back
Top Bottom