How do I protect my Data

[SuperG]

I have a client/server database system.
Data on the server forms,reports and paradox on the clients.

However, some of the users on occasion decide that they should enter info directly into the tables. By going into paradox itself and using the project user to navigate around. How can I stop them being able to access the data except from in the database forms?

I use Paradox 8, could upgrade to 10 if it would help.

Thank you for your time.

 

[ros]

For paradox tables, the simplest way is passwords.
Restructure the tables and add a password to all (can be the same).
Then add "addpassword("password&quot" to your form open method and removepassword("password&quot to your close method.

hth,
Richie

 

[SuperG]

I would do that but my manager is insistent that they be able to do their owns queries, I've been able to talk them down to read-only access when not in the forms, but I'm not sure how to make the tables read-only except for when they are in the actual forms.

Glenn

 

[ros]

Restructure same as above but add a second (auxiliary) password and make the all the fields readonly on the second password. This is the password you give to the users for interactive use. Test it out on a test table until you are comfortable with it. Exit and restart Paradox after you create passwords to test properly. You'll be unable to enter edit mode on the table with the auxiliary password.

HTH,
Richie

 

[SuperG]

Works Great Thanks

Glenn

 

[ibearian]

I was very interested to read of your solution. We have a simalar problem. Our staff query paradox via MSQuery in excel using the intersolv odbc drivers.

So my questions are

Does this work with intersolv odbc drivers ? or will they contiune to bypass the password and allow acess direct to the data ?

thankyou in advance

 

[ros]

Why not make a test table to check this out.

IOW -I don't know.
Richie

 

[JoeNg]

I found maintaining passwords could be a pain.
One strategy I have used and still using is publishing the data for public use. However, this would only work if the users DO NOT need up-to-the-minute data.

Here’s how it work, I publish or copy the data to a public directory on the file server. I usually do it at night with a scheduled job. The data are refreshed everyday. Only the data entry persons are allowed into the production data, while the rest of the company can access the public version.
This way your production data are protected. It makes life a lot easier in finding and fixing problem.