How to close and open access to SQL Server 2008 in Windows application?
Posted
by hgulyan
on Stack Overflow
See other posts from Stack Overflow
or by hgulyan
Published on 2010-05-25T13:05:16Z
Indexed on
2010/05/26
4:51 UTC
Read the original article
Hit count: 189
Hi,
I have a MS Access 97 application (but the question is general) working directly with SQL Server 2008 (without application server or anything).
Numbers of users can be up to 1000. Windows Authentication is used.
The question is:
How to handle modes, so
some users will be allowed to work in read-only mode
some users won't have access to db for some time
My versions:
Using a table with a mode id for every group of users, that will work the same way. On Form Load application will query that table for mode id.
Using trigger on the tables, that must work according to that mode. The trigger will query mode value and doesn't work if access is closed or it's in read-only mode
I know these are not the best solutions, that's why I'm asking for your advice.
There's one more point.
If the mode is changed to "access-is-closed" for a group of users, that group must not be able to query to DB starting that moment.
With first solution I wrote it won't work, because user can be in application at that moment and no form load event will work. How can I do this?
Is there any optimal solution?
Thank you. Any help would be appreciated.
© Stack Overflow or respective owner
