We have PCs running Access 2000 front-end data entry mdbs linked to SQL Server tables via ODBC.
Is there a way to alert a user that a record they are looking at is open for editing on another PC, without bogging the network down by much?
If you need a simple but flexible process for maintaining an audit trail of who created, edited, or deleted data from a table, or multiple tables, and you can do all of your work from within a form, this simple Audit Log will work for you.
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …