Access Replication Problem
Posted on 2006-05-25
Have multiple databases that are linked together, and was created in 97. Has since been changed to 2002-2003. Problem will not let me create replica. Missing MsysAccessObjects. If you copy this hidden file from new database to this database, I am able to create a replica. Now if I try to syn get error MsysAccessObjects is missing. If copy that file to replicated database it will syn up.
How can I get MsysAccessObjects to be in original database, like it is suppose to be, so when creating replica the file will be there. Do not want to try remember to copy MsysAccessObjects over all the time. Also by doing this it is creating an issue with the repair and compacting. Get error "Could not find field 'Data'.