Secure Replacement for Access Written in VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Scenario:

We have several SQL 2000 servers that our employees use by linking tables
through Access XP. They have read only access to several tables and views –
they also write their own views to get the data in a form that is useful for
them.

The problem is that the users are in a habit of not linking to the tables,
but rather, importing the data. This is a problem because despite numerous
warnings against unsafe practices they continue to import the data into large
unsecure Access databases thereby circumventing the security features of SQL
Server. The data should NEVER be local.

Frankly, if I can do it, I’m gonna try to eliminate Access from everyone’s
workstation. The security risk is too great. What I need then is a
replacement – a program that allows people to build and save queries, link to
several SQL Servers, and sort the data as required without the user having
the ability to pull the data for local storage. All the abilities of Access
without the ability to “Make Table†or “Import Dataâ€.

Is there a control that would help with this?
A program?
Thoughts? Suggestions?
 
How about replacing Access with a reporting tool like Cognos Impromptu or
Business Objects?

John G.
 
Back
Top