Preventing Record Locked

[Angelsnecropolis]

Scenario: About 15 PC's use a single access database file on a shared drive.
Everyone uses the file to track call data at a call center and it is utilized
many times a day by each person. For expediancy (due to talk times) each
person leaves the program up to be used at a moments notice. Since the forms
we use save data to a record the file will occationally LOCK and prevent
everyone else from using the file until the individual locking it is finished
with the record.

I tried to correct this error by On Dirty set timer for 10min. When 10 min
is up, and certain txt fields are NOT NULL, NOLOCK form opens (not tired to a
table), copies the data from from the original form, clears the original
file, and makes it NOT DIRTY. This has helped reduce the number of locks but
it still remains a problem.

I've read that it's best not to use a single file, on a shared drive, but we
must run reports on a whim using all the data that is being entered from all
the individuals. I don't know if we could do this if we have 15 seperate
files and tables.

Can anyone offer assistance? Is there a way to have 15 separate access files
on their individual PC's but able to run a report which will combile the data
from all 15 different tables? I hope this is clear enough.

Thanks.

 

[Piet Linden]

Scenario: About 15 PC's use a single access database file on a shared drive.
Everyone uses the file to track call data at a call center and it is utilized
many times a day by each person. For expediancy (due to talk times) each
person leaves the program up to be used at a moments notice. Since the forms
we use save data to a record the file will occationally LOCK and prevent
everyone else from using the file until the individual locking it is finished
with the record.

I tried to correct this error by On Dirty set timer for 10min. When 10 min
is up, and certain txt fields are NOT NULL, NOLOCK form opens (not tired to a
table), copies the data from from the original form, clears the original
file, and makes it NOT DIRTY. This has helped reduce the number of locks but
it still remains a problem.

I've read that it's best not to use a single file, on a shared drive, butwe
must run reports on a whim using all the data that is being entered from all
the individuals. I don't know if we could do this if we have 15 seperate
files and tables.

Can anyone offer assistance? Is there a way to have 15 separate access files
on their individual PC's but able to run a report which will combile the data
from all 15 different tables? I hope this is clear enough.

Thanks.

You mean the database is not split? So the same database contains all
the tables AND all the forms, reports etc? Accident waiting to
happen. Run the database splitter wizard, put the backend on the
network drive, and distribute Front Ends to everyone. This way
everyone shares the tables, but that's it.

 

[Angelsnecropolis]

But will I be able to run one report to gather all the data that each person
has entered?