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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|
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 |