Re: MSAccess get Query SQL source possible

Have you tried to access the system tables in an Access database with jdbc through just select statements in a default setup? That simply won't work, as it will complain about unsufficient privilegies.

But I won't say that there couldn't be other ways to override the security issues.

First, Thank you for all the input!
Yep, insufficient privilegies is exactly what I experience even with ADO queries. I will invesitagtte on getting the provileges for MSysObjects as this seems to be the most feasible way to me.

Ciao

....Jochen
.