Can a database be created from scratch using UCanAccess? How would this be done?

[David Sills]

The subject is self-explanatory. I have a need while iterating through a current database to create a new database to hold error records when the data is insufficient. Can this be done using UCanAccess? Thanks!

David Sills

[Gord Thompson]

Yes, you could create a second Connection using a connection URL like

jdbc:ucanaccess://C:/path/to/errors.accdb;newDatabaseVersion=V2010

 
which will create a new database file named "errors.accdb" if it does not already exist. You can use DDL statements to create tables in that database, then use DML statements to write to those tables.