adam brin

Hi Gord, Thanks. We'll take a look at the OBDC/JDBC bridge and other options. best, adam

Hi Gord, Just checking back here. We're still struggling with how to approach this type of problem where UCanAccess says that "user lacks privilege or object not found". We have a number of "queries/views" that are reporting this, and if it's a similiar issue to what's listed above (where the MSAccess SQL is valid, but not valid SQL for HSQLDB), is there a good way to test this? We're also struggling with how to better approach this, we don't have control over the databases we're being given, so...

cool, thanks! I hope it turned into a fun puzzle (even if it was tough).

Hi Gord, I'll see if there's a way to do this, but, ideally it'd be nice to not have to rewrite every query for every access database that we're passed. This does feel implementation specific to how UCanAccess handles these queries, is it possible that this is something that you could do within the tool? Re: issue 2, I'll see if the issue is having "data" in the database that's causing the NPE to fire. thanks

Hi Gord and Marco, Any additional thoughts on the NPE and the table permissions issues or anything else I can provide to help? thanks, adam

Looks like this error hides two other errors. I'm including the MSAccess Database that's causing this (with all of the data truncated). There's also (possibly related, but possibly not) a bug in Jackcess in how it hanldes joins: https://sourceforge.net/p/jackcess/bugs/141/?limit=25#c1ca Issue 1, table permssions/does not exist: DEBUG 2017-05-29 07:47:20,687 23837 [main []] (AccessDatabaseConverter.java:243) org.tdar.db.conversion.converters.AccessDatabaseConverter - specsums(JSW) SELECT [] | class...

Marco & Gord -- thanksf or the help. I didn't realize you could get the result of query that way. I was using Jackcess to read the SQL of the query out, and then running it via a JDBC query. If I can just do select * from {queryname} for any query, that solves my issue.

We have a crosstab query in Access, that doesn't seem to properly translate in UCanAccess, is there something we need to do to properly run a crosstab: -- crosstabburialpoints TRANSFORM Count([Points/burials(JSW)].ARTIFACT) AS CountOfARTIFACT SELECT [Points/burials(JSW)].FEATURE FROM [Points/burials(JSW)] GROUP BY [Points/burials(JSW)].FEATURE PIVOT [Points/burials(JSW)].MATERIAL; We get the following error: ~~~ net.ucanaccess.jdbc.UcanaccessSQLException: UCAExc:::4.0.2 unexpected token: TRANSFORM...