470,849 Members | 1,071 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,849 developers. It's quick & easy.

Secure Replacement for Access Written in VB

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?

Apr 12 '06 #1
2 1112
"Mad_Gerbil" <Ma*******@discussions.microsoft.com> wrote in message
news:DA**********************************@microsof t.com...
Is there a control that would help with this?
A program?
Thoughts? Suggestions?


I've commented here:

http://www.itwriting.com/blog/?postid=407

Tim
Apr 13 '06 #2
How about replacing Access with a reporting tool like Cognos Impromptu or
Business Objects?

John G.

"Mad_Gerbil" <Ma*******@discussions.microsoft.com> wrote in message
news:DA**********************************@microsof t.com...
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?

Apr 19 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by Matthew Sims | last post: by
reply views Thread by ian douglas | last post: by
5 posts views Thread by Paul Miller | last post: by
92 posts views Thread by Reed L. O'Brien | last post: by
4 posts views Thread by Shabam | last post: by
20 posts views Thread by Paul D. Boyle | last post: by
14 posts views Thread by Dave | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.