Articles and links about Microsoft Access or Microsoft Office Programming.
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.
I have been programming and supporting Microsoft Access databases since 1995. In 2007 I received the Access MVP award from Microsoft because I waste too much time writing newsletters and blogs. Why not sign up for one of my newsletters at http://www.vb123.com.au and look for newsletter on the left.