Access closes in design master mode (1 Viewer)

[SteveJones]

I have an application that when in design master shuts down when I attempt to open a certain form. I have traced the problem to a linked field from another table, by creating a new form and ommitting the said field, problem is its a required field!

If I copy the database (Backup) and run it as a replica it does not happen, if I then convert the replica to design master it happens.

Any suggestions please??

Steve

 

[dfenton]

Forms and reports should never be replicated. Only pure Jet objects (tables & queries) can be reliably replicated. It makes no sense to replicate front end objects, anyway, as pushing out updates to a front end is a one-way operation.

Of course, I assume that you've split your application, which is really the most basic requirement for deploying any multi-user app (and any single-user app where the developer has to work on the forms/reports/etc. while not interfering with the users' data).