CODEWITHSUNDEEP
javams-accessucanaccessjackcess
Mattizin
Mattizin

Reputation: 370

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?

Upvotes: 1

Views: 438

Answers (1)

Gord Thompson
Gord Thompson

Reputation: 123419

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

Upvotes: 2

Related Questions