After replicating a secured mdb, edits through any form crash the

[Guest]

Hi folks,
I am developing an access application that will hold confidential
information (so needs to be secured), and is needed out on site by our
engineers (so needs to be replicated to their notebooks).
Now that we are reasonably happy with the data design and the user
interface, I have run the User Level Security Wizard to secure the database,
then logged in and tested that the mdb still works ok - it does.
Next step: I ran Tools - Create Replica. Now if I try to edit any data
using a form, in either the design master or the trial replica, the
application crashes and sends an error report off to microsoft. I can
successfully edit data directly in tables, the issue seems only to arise when
editing through either of our two main data entry forms, or any of their many
subforms.
I have two questions: 1. is my overall strategy of first securing, then
replicating the database a sensible strategy? 2. any ideas what can be going
wrong with the form edits??? The crashes happen as soon as i move off the
edited record, either by moving the focus to a subform or by trying to
NextRec, PrevRec, LastRec or FirstRec.
Thanks in advance

 

[Joan Wild]

I have two questions: 1. is my overall strategy of first securing,
then replicating the database a sensible strategy? 2. any ideas what
can be going wrong with the form edits???

Replication is intended for data (tables) *only*. You should not replicate
the other objects.

You need to split the database into frontend/backend and replicate only the
backend. Each laptop will have a replica of the backend. Put a copy of the
frontend on each laptop, linked to its replica. When they return to the
office, you just synchronize the backend replicas.

If you make changes to the frontend, just copy it over their existing
frontends.

As for the order:
Secure
Split (but don't use the splitter wizard; do it manually
http://www.jmwild.com/SplitSecure.htm)
Replicate

 

[Guest]

Thank you thank you thank you!!! I'll get on to that this afternoon. Thank
you!!

 

[Joan Wild]

Thank you thank you thank you!!! I'll get on to that this afternoon.
Thank you!!

You're welcome! If you have further questions about replication, I suggest
you post them in the replication newsgroup at
http://support.microsoft.com/newsgr...ft.public.access.replication&sloc=en-us--Joan WildMicrosoft Access MVP