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.
Microsoft Access is a fully capable database and it's primary limitations is the number of concurrent users it will support. Generally, we recommend a limit of 10 to 15 users.
Did you know you don't need to move to SQL/Server to run and manage your Access database on the net. There are many alternative solutions. Among them are Amazon's AWS cloud services and various hosting services in nearly every state.
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