I am developing a small package using VB 6.0 and MSAccess 2000 Database. In that application, I am using two databases. One database, I am always refreshing the data (deleting) whenever I transfer the data but the database file size is keep on bulging (increasing the size). I would like to know how to OPTIMIZE that database from VB. (Note: In MSAccess there is a option to optimize the database but I wanted to do through VB). It is possible for me to advise me on this.
Another request is how to create a MS Access Database from the Visual Basic Application. My requirement is whenever the application is launched the database has to be created and when the applications shuts down that database has to be deleted. Please advise for the these two queries.
Thanks, Boopalan K.