limit access to query

[Rascal]

I have a database that I have set up and have created a log in form that requires a name and password. It works well. I have also password protected 1 form, which also works. The users who need access to the form have the password, all other forms are accessible to all. I am using DH QBF so that users have access to certain queries. Right now all users have access to those queries, what I would like to do is limit views to 1 query or certain fields in that query if I can, while allowing others to have full access. Is this possible without going through the headaches of setting up the Access security wizard which really isn't necessary for this database. This database will be going accross the country so I will not be maintaining it and the users there want something simple to use.
Thanks:

 

[BigJimSlade]

Wow, I don't think I would ever try that with Access. I would use SQL Server to maintain who had access to what.

I don't know anything about DB QBF, but aren't you limited in Access as to how you can grant authorization to given fields?

 

[RV]

Is this possible without going through the headaches of setting up the Access security wizard

As far as I know, the answer is no.

I am using DH QBF so that users have access to certain queries.

Through forms you mean I hope
Why don't you simply see to it that you hide the database window so users can't see hence do not have access to queries?

RV

 

[Rascal]

Through forms you mean I hope
Why don't you simply see to it that you hide the database window so users can't see hence do not have access to queries?

RV[/QUOTE]

The database window will be hidden but with the DH QBF it is a form that allows access to certain queries where the users can pull various information. This does not affect the queries themselves and they cannot alter or change them. But there is 1 field in 1 query that certain users should not have access too, which is what I want to block.
To see what I am referring to for the DH QBF go to the following site http://www.rogersaccesslibrary.com/OtherLibraries.asp
and it's Duane Hookom's Query by Form"