Compact Access Database from VB6?
Right. Check out JRO (Jet Replication Objects) which can compress/repair Jet
See www.microsoft.com/data for leads.
William (Bill) Vaughn, Author, Trainer, Mentor
Microsoft Pacwest Regional Director, MVP
"ADO and ADO.NET Examples and Best Practices for VB Programmers--2nd
Edition" (ISBN: 1-893115-68-2)
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
> Is there any way to perform the same compacting in VB6 code (NOT vba) that
> you can do in Access with the Utilities menu option (Compact and Repair)??
> Need to do this periodically on a big file (50Meg) to keep access time
> reasonable, and don't want to force the client to buy Access...