I have an application that I am planning to distribute as an Access Runtime application. For archiving and data storage, I need to dynamically create ANOTHER database (or multiple databases) from within my application. This is because the volume of data can become quite large, exceeding the 1GB limitation. So I have a separate database for each year, then just select and merge in my application. It works pretty well, but the outside databases must be set up first.
I can create new tables (with CREATE TABLE) but not a new database. (using ADODB)
When I use CREATE DATABASE it says Operation not allowed when object is closed. But if I say .OPEN, it says object not found.