Thursday, May 23, 2013

2000, 2003, 2007, 2010 Tables Are Stored Identically

I took a database with only tables and indexes in Access 2000 format that had 400 tables. Compacted it. Converted it to 2003 format. Converted it to 2007 accdb using Access 2010.  All 3 databases were exactly the same size.

Conclusion: Nothing actually changed in Access data storage in a decade through 4 versions.

Garry Robinson Access MVP 2006-2013

No comments: