SmashingPiggy
Nov 3rd, 2000, 02:09 PM
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.
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.