Append to new table vs Update one table

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?
 
J

Jake F

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?
 
S

S.Clark

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.
 
J

Jake F

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Append Copy of Table 9
Append only Null records in table 2
Appending records to new table using field names as values 2
Update and append records in one table based on shared primary key 4
Append current record from one table to another 11
Linked Excel Table, Update Table 1
append query to table with autonumber pk 2
Copy selected records from two tables to two new tables 2

Top