%dim crumb crumb="Inventory Calculations Multi-User" Crumb2="Inventory Calculations Using VBA Recordset Methods" crumb1="Recordset Processing Inventory Calculations Example" %>
Open Email Using SendObject Access Download
User Inactivity Logout VBA Code
Disable Shift Key Demo
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
Union Query (Advanced) Access Tutorial
How To Fill Fields From Combo Box
<% gnum="2600800820" %>
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.
MS Access 2003
<% Response.write "Copyright 2000-" & year(now) & " Blue Claw Database Design" %>
MS Access 2013, Access 2010 & Microsoft Office 2007