Help!!

[Sbacon]

We're using Access 97 for a huge data entry endeavor. Five of us are using Forms to enter data on a shared network drive, but we're having save conflicts. Can more than one person work on a form at a time (we're not working on the same records)?
Please help! Thanks.

 

[Adrianna]

Yes, more then one person can work on a form at one time.

You may have to worry about the database being set to Open Exclusive (usually if the security is set up right, then only the Admin will have that ability).

You may also have to worry about the refresh interval.

I would go to Tools-Options-Advanced- and check that the refresh rate is 60 sec or less! and that the Default open mode is set to SHARED!

If each of you are simple entering data and not editing it....you should have your form set to DATA ENTRY. if it is not set this way...then technically you are all trying share the underlying table at the same time.

 

[Sbacon]

We're up and running again. Thanks Adrianna!

 

[DBL]

If this is being used by five users on a network, you really need to think about splitting the database in to backend and frontend if it's not already - that will stop a lot of the conflicts. As Adrianna says, make sure that the default open mode is shared and also that the default record locking is set to EDITED RECORD.

Using the database splitter wizard, found under Tools>Database Utilities>Database Splitter. Split the database into backend (data) and frontend (forms, queries, reports, etc). Put the backend in a shared folder on the network and either give everyone their own copy of the frontend on their PC (my preferred option) or have everyone access the same frontend through the network too.

If you don't have it split at the moment, you are likely to run in to a a lote of problems - which could include the corruption of the database. Search the formum for Split Database to find a mountain on the subject.