javams-accessucanaccessjackcess

UCanAccess/Jackcess Create View/Save Query in Access

In Access you can save queries in a view. In my Java project I use UCanAccess with the underlying Jackcess library. The normal SQL Statement CREATE VIEW <name> AS <Select Statement> is not supported by UCanAccess at the moment and I don't know when it will support it.

Can Jackcess perform the equivalent of CREATE VIEW?

Solution

  • No. Jackcess can retrieve the SQL string of an existing saved query but it cannot create new ones.