How to tune the Access Database

devisrin4's Avatar, Join Date: Jan 2007
Light Poster
hi

before writing the code in MSAccess 2003, the size of the database is 38MB after wrting the code to transfer the data of one tble to another table it is showing it as 272MB.i don't know what the problem is. so plz help me on this

Thank You
Srinivas
0
shabbir's Avatar, Join Date: Jul 2004
Go4Expert Founder
Try exporting the database into 97 or 2000 format and you will see the size of the database decreasing considerably. I used the above techniques when in college to email the databases.
0
devisrin4's Avatar, Join Date: Jan 2007
Light Poster
I think if we convert the databse to 97 ot 2000, we might loose the features and securitys that are there for 2003. but i got solution by doing compact and repair databse from tools mesnu -> databse utilities.

Thanks for sharing your thoughts