Access 97 Security

[Savil]

Hi All
Using Access 97 db shared on a network. Some of the data is individually sensitive so I have set a password, disabled the shift key and all the other good bits but am intrigued as to how to prevent one of the users creating another db and linking to the tables and viewing data that does not belong to him/her?

Thanks

 

[KenReay]

Hi

A couple of things to try (when you are sure you have a backup copy!)

Have you looked at Security?, ie the Access security built into the product which allows you to specify users who may access the databse using a workgroup?

Have you considered hiding the tables. But beware there was a bug in earlier versions which caused hidden tables to be deleted on compact.

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[Ed2020]

My preferred solution is to create a separate launcher application for users to open the system with.

This application can pass the user name and password credentials to MS Access as part of the command line. This way users don't need their login details. Without login details they can't import from or link to the database.

Ed Metcalfe.

Please do not feed the trolls.....

 

[Ed2020]

Another alternative is to not allow any rights to the data tables for users. Perform all data processing in a separate workspace opened with a dedicated account with the necessary rights. This solution feels more elegant to me, but could be a *lot* more work.

Ed Metcalfe.

Please do not feed the trolls.....

 

[Savil]

Hi
Sorry I was late to respond as I have been away.
I like the launcher application method but am a little unsure as to how to open another database with a password and then close the launcher db.

Thanks

 

[Ed2020]

Savil,

The shell command can be used something like this:

shell "C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE /runtime 'Y:\Shared\NGSRV51H003\TeamData\BSS Offline Systems\Status LIVE\D159-Vader2000\D159_Vader2000_App.mdb' /Wrkgrp 'Y:\Shared\NGSRV51H003\TeamData\BSS Offline Systems\Status LIVE\D159-Vader2000\BSSSecured.mdw' /User UserNameHere /Pwd PasswordHere",vbMinimizedFocus
Application.Quit

Ed Metcalfe.

Please do not feed the trolls.....