Go4Expert

Go4Expert (http://www.go4expert.com/)
-   MS Access (http://www.go4expert.com/forums/ms-access-forum/)
-   -   How to tune the Access Database (http://www.go4expert.com/forums/tune-access-database-t2674/)

devisrin4 24Jan2007 00:19

How to tune the Access Database
 
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

shabbir 24Jan2007 08:29

Re: How to tune the Access Database
 
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.

devisrin4 24Jan2007 09:05

Re: How to tune the Access Database
 
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


All times are GMT +5.5. The time now is 09:27.