is it possible to password protect a sql query

[zeta]

Hello.

We know it's possible to protect VBA code with passwords. Is there something analog to protect a sql source code so users can run it but can't see the actual sql?

thanks.

[jforbes]

There is no way in Access alone to lock down the database's data that can't be undone. Access isn't secured and it isn't designed to be secured.

The only security you have available in Access alone is file based security where you can put the data on a File Share and then maintain which users have read/write access to the File Share. Taking that a step further, you can split your Access databases up by security levels and place the different databases on separate File Shares so that you can have one front end, but different levels of data access based on the users permissions. This is a lot of work, but it will work.

In the file based security model, if the user has access to part of a table, they have access to all of the table. This still may not be desirable and if you need to lock this down further, you'll need to hide the database from the user altogether. One way to do this is to put it on a Webserver and create web services to retrieve your data so that the user never directly queries the database. That's a deep subject that people have written books on.

[zeta]

mmm... i think i will just try to invoke the query from vba.

thanks for the answer.