block users from running access reports

From: Ben Cheek (bcheek@sacomputer.com)
Date: 07/24/02 

From: "Ben Cheek" <bcheek@sacomputer.com>
Date: Wed, 24 Jul 2002 08:15:56 -0700

The goal is to block unwanted users from running access
reports. My plan is to change the sa account's password,
go to each workstation, and put the new password in their
odbc dsn setting. But, I think when they run an access
report they can just use the existing dsn connection on
their machine to run a report, because a connection has
already been created with the correct password. Do you
have any other ideas on blocking users from running an
access report? The same users must be able to connect to
the database for their accounting program.

Relevant Pages

  • Re: block users from running access reports
    ... >The goal is to block unwanted users from running access ... >odbc dsn setting. ... >report they can just use the existing dsn connection on ...
    (microsoft.public.sqlserver.security)
  • Can you merge and email with a report?
    ... someone will have some suggestions on other ways to accomplish what I ... I am running Access 2002. ... together (usually by make tbl quieries) and then I run a word merge to ... information is mixed of check boxes and text and the report has printed ...
    (microsoft.public.access.reports)
  • Re: Dynamic report printing
    ... mentioned I'm running Access 2000. ... When I execute the code I get a compile error: ... Allen Browne - Microsoft MVP. ... the report based on which "Type" sections they need to print. ...
    (microsoft.public.access.formscoding)
  • Date format wrong
    ... I have an Access 2000 program that reads the date in d/m/yy instead of m/d/yy ... The program is running Access 2000 runtime on a WinXP Prof. OS with Office ... on open; however, it opens to the wrong date. ... today's date on the calander for the date range of data to report. ...
    (microsoft.public.access.reports)
  • RE: Report is Running Very Slow
    ... I was running Access 2003 for a long time and I was very happy with it. ... Anyway, the Query seems to run fine, but the Report that the Query ... Everything else seems to run at reasonable speeds. ...
    (microsoft.public.access.reports)