Difficulties with creating Replicas 1

[osjmgr]

I am trying to create a replica of my database so I can make changes to the Design Master while my users use the replica. However, after replicating, when I open the Design Master I get the following error message: "You tried to commit or rollback a transaction without first beginning a transaction" and I am not allowed to make any changes to the database. I believe this error occurs when Access cannot find the code.

My design master works fine until I synchronize with the replica. I am using autonumbers in three tables. After replicaton, Access converts them to random numbers. Some numbers are in the millions and/or negative.

Anybody have any idea what is going wrong? Could it be my Autonumbers that are throwing things off? Any solutions?

Thanks.

 

[lupins46]

I don't know what the problem is but it is NOT the autonumbers. Autonumbers are changed to random values in replicated databases to avoid the possibility of two replicas generating the same autonumber. So this is normal behaviour.

Do you have code which runs on startup?
If so hold the Shift key down while you start the database and then you will bypass it and maybe can get to the design.

 

[osjmgr]

lupins46:

Thank you for the information. Based on my further readings, it appears that creating replicas in Access was never intended for forms, queries, reports, etc. It was only intended for the BE. I think will try splitting my database, mainting the BE on the server, and converting the FE to an MDE file and distributing it to the users' desktops. Do you have an opinion on this strategy?

 

[lupins46]

For an in-house multiuser config that sounds just about right to me.