Open Email Using SendObject Access Download
Send Email Microsoft Access Tutorial Download (Advanced)
Programming MS Access Security Alternative
Single User Inventory Calculations Download
How To Perform Multi-User Inventory Calculations
Make Dependent Combo Box Code MS Access Tutorial Download
Union Query (Advanced) Access Tutorial Download
How To Fill Fields From Combo Box
Inventory software data management in a multi-user Microsoft
Access environment must be able to take into account locking of data records.
Recordset edits should use error handling to prevent the loss of data when
updating records that may be locked by other users of the database.
In this database example we use the Recordset Edit and After Update commands combined with error handling to check for general errors and also check for error number 3188, locked record. If the program encounters any error then the edits are undone and the user is warned of the problem.
Access does not perform true record locking. Instead Access locks a page of data on this disk. The page contains approximately 2000 bytes of data. An efficiently designed inventory table may have as many as 200 records locked at one time - this could represent a significant portion of a table depending on the amount of inventory records.
Here is the afterupdate event code we use:
Private Sub Qty_Out_AfterUpdate()
Use this link to download our Microsoft Access Multi-user Inventory Database.
Copyright 2000-2013 Blue Claw Database Design, LLC