References change when using CeateDatabase

[Kevin Robson]

I am struggling with what should be a simple task:

I have a working A2K database that uses the following references:

Visual Basic For Applications
Microsoft Access 9.0 Object Library
Microsoft DAO 3.6 Object Library
OLE Automation
Microsoft Visual Basic for Applications Extensibility 5.3

Question 1:

What references should I have, are these the standard References for A2K or have I got a non-standard set?


Question 2:

The database saves a selection of its data to an external database file - filename.mdb, which is used by another programme.

When I create this database using:
Set MyDbase = DBEngine.Workspace(1).CreateDatabase.(MyFileName, dbLangGeneral)

The database creates OK and I can load the necesary tables and data into it, no problem. Having closed the main application, I click on the new database to open it in the standard manner. It opens OK and the tables / data are fine.

But, the references for this new database are now:

Visual Basic For Applications
Microsoft Access 9.0 Object Library
OLE Automation
Microsoft ActiveX Data Object 2.1 Library

Why have they changed?
Have I missed something in the create sequence to replicate the references of the Master programme?

I have searched the forum but can find no assistance.

Any help would be appreciated. Thanks.

 

[RuralGuy]

The references of the new db appear to be the default references used by Access when making a new empty db. Kind of silly that CreateDatabase is DAO and the reference is ADO. AFAIK the way to duplicate existing references is to use the CompactDatabase Method on a closed mdb.

 

[Kevin Robson]

Thanks

RG,
Your right it 'is' sort of silly!
I will give the ComapactDatabase method a try.

Many Thanks

 

[RuralGuy]

Cheers! Have fun!