Differences between Access 2000 and Access 2013

[rileydog]

Size differences between Access 2000 and Access 2013. For some of my users, I converted an Access 2000 database to Access 2013. When files were created for a new year in the Access 2000 database and were emptied, the file size would show a zero size. However when an Access 2013 file is created for the new year and all the data is removed from the filze, the file size shows it is the same size like it still contained data. Thus can you tell me why the file size remains the same even though there is no data in the file? Is there something I can do to make the file size be set back to zero?

 

[Micron]

Thus can you tell me why the file size remains the same even though there is no data in the file?

I cannot for sure because there are lots of reasons for bloat (non-query def sql, over-use of temp/query made tables, adding/deleting records, renaming objects, not releasing memory allocated to DAO recordsets, etc.).

Is there something I can do to make the file size be set back to zero?

Compact/Repair option; or opening db with command line switch to do a deeper level compact/repair. However, I do not see how even a back end with one empty table and nothing else could have a file size of zero. It does not sound possible.