Access2000 and Access97 DBs at the Same Time

[SmashingPiggy]

To All,

Thank you in advance for your support.

I have only been programming in VB6 for a few months now, but have been fairly successful. I have run into a problem accessing both Access 2000 and Access 97 databases at the same time from the same VB program. I am using ADO (MDAC v2.5) to access that databases.

I have a database, DBA, that comes from a vendor product and is MS Access 2000.

I have a database, DBB, that comes from a vendor product and is MS Access 97.

I have created a database, DBC, that is MS Access 2000.


I want to take all completed records from all tables in DBA and move them to DBC. When finished with the move I want to delete all moved records in DBA.

I want to take all completed records from all tables in DBB and move them to DBC. When finished with the move I want to delete all moved records in DBB.


DBA and DBB are then updated by the vendor programs on a continuing basis.


Here is the problem: When I run the compact command to compress the database, DBB (MS Access 97) gets destroyed!! I tried calling the 3.5 Jet Engine instead of the 4.0 but it doesn't seem to work. How do I compact both a 2000 and a 97 Access database from the same program.

[vbuser1976]

I don't think you can. Access 2000 is very weird. It has a tendency to dominate all other databases. I may be wrong, though.