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
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.
Are you just starting out on your quest for a database? Need some advice or someone to bounce ideas off of? We are here and will be happy to chat with you on the phone and discuss options to your situation. Visit our contact page and give us a call.
Are you looking for an MS Access template database? We have many for sale in our Access Template and Examples Software section.
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
Copyright 2000-2017 Blue Claw Database Design
MS Access 2013, Access 2010 & Microsoft Office 2007