I have a customer that has an Access backend database that has reached the 2GB limit. The table has approx 80,000 records and has a field that embeds scanned PDF documents. Is there any way to tell which field or fields is causing the table and database to be so large. There are about 250 fields in the table but the math doesn't add up from what he tells me. The bottom line is we are not sure why the database is so big and how can we figure out why?
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.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page.
The problem with sub-reports and headings:
Add a dummy group to the sub report using the expression =1:
Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks.
Specify a start-up form through options:
Specify an Autoexec macro: