Sunday, March 11, 2012

Blocking ms-access

Hi,
There is a way to block all request that come from a ms-
access ?
I am working for a company where users always connects to a SQL database to get information they need (because applications don't provide them).
The problem is when the users run queries, they lock almost all database preventing others users to work.
I can't remove SQL permissions because the application depends on it to run and i can't uninstall ms-access from the users because they need the information to do their job.
I am configuring a log shipping environment with "read-
only" permission and trying to identify users running ms-
access querying sysprocesses (to change the odbc to another server) but not everyone that uses ms-access are logged in sysprocesses as "Microsoft=AE Access", sometimes the application in sysprocesses is empty and i can't identify what user is running.
Any suggetion ?
Thanks,
Julio CarvalhoYours is probably the best solution. If another SQL Server isn't an
option due to cost or whatever, the data could always be pushed out to
an Access mdb and users could run reports by linking to it instead of
the server.
-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446
On Tue, 22 Jul 2003 15:26:18 -0400, "Stefan" <st@.email.net> wrote:
>Julio,
>I have exactly the same environment here. We had to set up another server
>and use transactional replication to push data. Then all Access clients were
>pointed to this new box where they could run their reports without
>disturbing any other production application.
>"Julio Carvalho" <jc.carvalho@.terra.com.br> wrote in message
>news:01ec01c3507c$b7fbb8c0$a401280a@.phx.gbl...
>Hi,
>There is a way to block all request that come from a ms-
>access ?
>I am working for a company where users always connects to
>a SQL database to get information they need (because
>applications don't provide them).
>The problem is when the users run queries, they lock
>almost all database preventing others users to work.
>I can't remove SQL permissions because the application
>depends on it to run and i can't uninstall ms-access from
>the users because they need the information to do their
>job.
>I am configuring a log shipping environment with "read-
>only" permission and trying to identify users running ms-
>access querying sysprocesses (to change the odbc to
>another server) but not everyone that uses ms-access are
>logged in sysprocesses as "Microsoft® Access", sometimes
>the application in sysprocesses is empty and i can't
>identify what user is running.
>Any suggetion ?
>Thanks,
>Julio Carvalho
>

No comments:

Post a Comment