Records lock up after changes made

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Our database is out on the network and if a user is updating a record no one
can view the record. Normally the record should be unlocked after the user
is done inputting the data, however our records are locking up and allowing
no one else to view or modify records.

I have tried compacting, splitting, etc. and dont know what to do to fix
this problem.

TIA
 
Susanne

Depending on the locking scheme used, the record (and nearby records) can be
locked until the changes have been saved. You didn't mention what mechanism
you are using to <Save> the updates.
 
Susanne

Define "entered"...

You can make changes to an existing record via the table, a query, or a
form, but, if I recall correctly, the changes are not saved until you leave
that record.

I believe that, although you begin a new (JET) record when you start
entering data into it, it hasn't been saved (committed) until you explicitly
save it or go to another record.

Are you working with an Access back-end (JET), or with SQL-Server, Oracle,
or ??? as a back-end data store?
 
Back
Top