Query Access to Secure Database

[msp]

I have a database that does not allow the users to view the "database window". The users are also locked out from using shift.

However we have a requirement for a "Query User" which would have "READ-ONLY" access to querys.

Is there a command that can open up the database window even if it is not visible on start up. So that only the query user can gain access to the database query window.

 

[KenHigg]

I would consider setting them up with a seprate db and attach back to the main db table(s). Then let them build their custom queries there.

kh

 

[msp]

The problem is than we would be tracking 2 database for upgrades

 

[KenHigg]

Do you want them to be able to create or modify queries?

kh

 

[msp]

They can create and modify queries...

 

[KenHigg]

Maybe just me, but I'd preffer the second mdb with attached tables method. As far as allowing view to the db object window based on some login criteria, I'm really not sure... Sorry - Maybe someone else has a suggestion...

kh

 

[msp]

However they only have read_only access to the tables

 

[msp]

Thanks Ken, I am looking at the posibility of having two DBs