I'm moving an Access database to SQL using the Wizard. All the tables convert OK apart from two. I've discovered it is related to date fields - if I copy the tables, remove all the date fields and then try it works fine.
I've tried migrating just the table structure and using an append query but this errors with an "Overflow" message. Again if I do the same with the date fields removed it works.
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. …