im looking to compact and repair a database. my databases exist in access 2002 and im using ado in vb.
what i dont understand is why i need an old database and a new database. heres some code that i found on the net
Dim JRO As JRO.JetEngine
Set JRO = New JRO.JetEngine
JRO.CompactDatabase "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\myData1.mdb", "Provider=Microsoft.Jet.OLEDB.4.0;" _
& "Data Source=C:\myDataNewName.mdb" & ";Jet OLEDB:Engine Type=5"
if someone could enlighten me on what this new database thing is, and how to get this working, id greatly appriciate it