ADO: Compact Database?
Posted on 2000-04-26
ENVIRONMENT: VB6 SP-3, ADO/ADOX 2.1, Access97 MDBs
How can I programmatically compact a password-protected Access97 database, using straight ADO (no data controls or anything other than straight code)?
I know that I can open this password-protected MDB by using this in the connect string:
"Jet OLEDB:Database Password=$0mePa$$w0rd;"
but I'd also like to be able to compact it.
Thanks for helpful help.