Database properties

[Doug]

When I create a database in visual basic 6.0, the SummaryInfo & User-Defined containers are not created. But if I create a blank new database through access 2002 they are created. My question is can I create these through VB and if so how ?

Thank
Doug

 

[TC]

If they are truly >containers< (in the VBA sense of the word), you will not
be able to create them from VB, AFAIK. DAA does not expose any methods for
creating containers. Access would do that via direct calls to the Jet API, I
imagine.

HTH,
TC

When I create a database in visual basic 6.0, the SummaryInfo &

User-Defined containers are not created. But if I create a blank new
database through access 2002 they are created. My question is can I create
these through VB and if so how ??

 

[TC]

... DAA ...

DAO

 

[Tim Ferguson]

When I create a database in visual basic 6.0, the SummaryInfo &
User-Defined containers are not created. But if I create a blank new
database through access 2002 they are created. My question is can I
create these through VB and if so how ??

There are two possibilities:-

1) You and your users have access to the Access GUI in order to maniplate
the database window, create queries and reports and so on -- in which case
the structures will be there

2) You and your users do not have access to the Access GUI -- in which case
you will not miss them.

If you want to hide information in the database, you can always use the
Database.Properties collection. AFAIK, there is nothing else of interest
except when using the GUI. More information please?


Tim F