Microsoft Access 2007 table unusually large
Posted on 2013-06-03
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?