Hi! I've been trying to compact an ms access database, yet, without getting a separate destination (compacted) mdb file, i.e. I want to keep my old mdb file in compacted shape.
I've tried the following piece of code:
Dim jro As JRO.JetEngine = New JRO.JetEngine()
jro.CompactDatabase("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\database.mdb, "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=c:\database.mdb)
but it seems that jro.CompactDatabase method doesn't like the source and destination file to coincide...
Thanx in advance!