A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Records lock up after changes made



 
 
Thread Tools Display Modes
  #1  
Old March 12th, 2005, 02:19 PM
Susanne
external usenet poster
 
Posts: n/a
Default Records lock up after changes made

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
  #2  
Old March 12th, 2005, 11:43 PM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

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.

--
Good luck

Jeff Boyce
Access MVP

"Susanne" wrote in message
...
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


  #3  
Old March 12th, 2005, 11:51 PM
Chuck Moore
external usenet poster
 
Posts: n/a
Default

Jeff,

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

Thanks

Chuck

"Jeff Boyce" wrote:

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.

--
Good luck

Jeff Boyce
Access MVP

"Susanne" wrote in message
...
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



  #4  
Old March 13th, 2005, 03:31 PM
Susanne
external usenet poster
 
Posts: n/a
Default

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

"Jeff Boyce" wrote:

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.

--
Good luck

Jeff Boyce
Access MVP

"Susanne" wrote in message
...
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



  #5  
Old March 14th, 2005, 12:10 AM
Jeff Boyce
external usenet poster
 
Posts: n/a
Default

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?

--
Good luck

Jeff Boyce
Access MVP

"Susanne" wrote in message
...
Aren't records automatically saved to a table when they are entered?

"Jeff Boyce" wrote:

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.

--
Good luck

Jeff Boyce
Access MVP

"Susanne" wrote in message
...
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




 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
validation of sequential numbering of records Ted New Users 5 April 20th, 2005 05:31 PM
Unmatched Query Mess Natalia Running & Setting Up Queries 8 October 28th, 2004 02:36 PM
code a range of records? TreDogg103 Running & Setting Up Queries 1 October 26th, 2004 05:51 PM
New records can't be seen rleblanc Using Forms 6 August 14th, 2004 02:43 PM
Copying new records John General Discussion 0 June 25th, 2004 04:02 PM


All times are GMT +1. The time now is 10:41 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.