Append to new table vs Update one table

  • Thread starter Thread starter Jake F
  • Start date Start date
J

Jake F

I'm having record locking issues and am not sure if putting the mde file on
everyone's computers will be the solution if they're all looking to one back
end file, or if I redo my database so that instead of the users changing one
table it appends information to a new table. I believe that would mean the
records will not be locked? Any advice?
 
Both the back end and front end files have a ldb file when being used, but is
it the front end ldb that is causing the record locks in which case having an
mde file on everyone's machine will fix the problem?
 
What kind of record locking issues?
How are the users locking the data? (i.e. from a form, directly in table, etc)
Distributing the front end is always the right answer.
 
The users are editing a single field in a table through a form. Would it
also help if I used a query to populate the form instead of going directly to
the table or that wouldn't matter? Still, each user having a copy of the mde
file on their machine is the way to go?
 
Back
Top