Does ADO have the ability to create a new database if it doesn't exist?


Do the ADO components have tools to allow the creation of a database
if it doesn't exist, mainly Access databases?


Is there also some way to do a compaction on the table while it is
still open? An app I created regularly empties a table and refreshes
the data from a remote source, and I realized that the way the Access
MDB databases grow is quite ridiculous.

It is bound to be reaching hundreds of megabytes or gigabytes within a
month as users have to refresh it when new records are created,
whereas the first update on a new table takes it to only 9Mb

Because it is a TrayIcon program kept running all the time, the
chances of getting all the users to log off for a Compact and Repair
process to be run manually is virtually nil. Are the new versions of
Access like 2003 and 2007 free of this problem?

Will switching the system to a linked Dbase format fix this problem?

.

Quantcast