473,382 Members | 1,775 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,382 software developers and data experts.

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 1199
"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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

10
by: Matthew Sims | last post by:
I've been performing search after search all over the internet reading up on all topics about making PHP secure with MySQL. There's a lot out there and not many concrete examples on how you should...
0
by: ian douglas | last post by:
Hey all, Anyone have a wraper written as a drop-in replacement for PDFlib? That is, use their function names, parameters, pretty much identically? I'm making some slight modifications to an...
5
by: Paul Miller | last post by:
We've run into minidom's inabilty to handle large (20+MB) XML files, and need a replacement that can handle it. Unfortunately, we're pretty dependent on a DOM, so a pulldom or SAX replacement is...
92
by: Reed L. O'Brien | last post by:
I see rotor was removed for 2.4 and the docs say use an AES module provided separately... Is there a standard module that works alike or an AES module that works alike but with better encryption?...
6
by: Billy Jacobs | last post by:
I have a website which has both secure and non-secure pages. I want to uses forms authentication. How do I accomplish this? Originally I had my web.config file in the root with Forms...
4
by: Shabam | last post by:
I'm developing an application and want to have the "remember me" feature, so that users don't have to log back in again in the next visit. The problem here is, what happens if the user's cookie...
20
by: Paul D. Boyle | last post by:
Hi all, There was a recent thread in this group which talked about the shortcomings of fgets(). I decided to try my hand at writing a replacement for fgets() using fgetc() and realloc() to read...
7
by: Seth | last post by:
I have noticed that the id of my session object changes when I switch from a non-secure to a secure connection. What I'm trying to do: I have a cookie that is built on the non-secure side of...
14
by: Dave | last post by:
Hello, Not sure if this is php related or not, but i'd like to have certain users who have the ability to upload files to my site, and others to download files. I thought about .htaccess and...
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.