Busy converting an older VB6 application which uses DAO to C# and VB.NET, using an ODBC driver. Is there an ODBC equivalent of the CompactDatabase function in DAO?
Later we intend to change to a different database such as MySQL or SQL Server, but for now we are still using the Access (.mdb and .accdb) single database files.
No, the Access ODBC driver cannot compact a database.