Depends on what you mean by a "database". If you mean you want to allow
users to create their own complete Access mdb files, well, then a simple
message box telling them to go run their own installation of Access would
suffice :-)
But if you mean to create their own tables, fields, queries, etc for
storage in your running application, then just use VBA, which provides
methods for completely defining and adding new objects to the current mdb
via code (you can even add new code, and then run it, too!).
This is, however, too complex a topic to fully explain here. Get a good
book on it.
--
Pete B
Quote:
> Why is it so difficult to find an easy way to have the user navigate
> through different databases in Access. I would like the user to be able
to
> create an empty database at runtime and name it whatever they want.
Doesnt
> any have an example for download, or does Access have an add-on or
> something. Doesnt most applications require using different databases.
> Please help me. I am in a desparate mode.
> Sean Moore