Records lock up after changes made

[Susanne]

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

 

[Jeff Boyce]

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.

 

[Chuck Moore]

Jeff,

Great News. I should have expected that from MS Access.

Thanks

Chuck

 

[Susanne]

Aren't records automatically saved to a table when they are entered?

 

[Jeff Boyce]

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?