I have a form with a procedure that updates all records in the data set. Using SQL is the most efficient way to do this (rather than looping through the form's recordset). But if I use CurrentDb.Execute strSQL, the form barks at me about another user altering the recordset. Is there a way to run the SQL within the scope of the form? Perhaps a DAO or ADO command?
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications. You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
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.
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship.
Add the tables:
Create the relationship:
Decide if you’re going to set referential integrity:
Decide if you want cascade upda…