Urgent I need to know How to protect the database from users 5

[Guest_imported]

I have users that change report and delete stuff out of the database. Who do I protect the database from them I want them to be able to use it. I do not want them to be able to change the design of the report, forms, or queries. The computers that this database is going on are stand alone computers. There are no user logons for their computers. I just turn the computer on and their everything is. So security accounts would not work with it. Doing User-level security did not work and permission did not work. I am useing Access 2000. Could someone please help me. These people will be messing this database up just like they did the other one if I do not find something to protect it. Is there anyway to change the toolbar show they can not go into the design or delete anything?

Tig

 

[hermanlaksko]

Via Tools/Security you can run the user-level security wizard this should do the trick.
Try to play with poss in security via user group accounts.
I allways create a user (myself) this user has all the rights and the user admin only has the rights that I want my end user to have.

 

[danvlas]

You could hide the database window, disable stuff in Startup and disable the Shift key. In this way you'll force them to work only from forms.
So, follow these steps:

Tools->Startup
Clear all checkboxes
Display Form - select your switchboard.

Open a new module.
Change
Option Compare Database
with
Option Compare Binary

Paste the following code:

Sub DnDatabaseKey()
Dim Answer As Boolean
Dim myprp As DAO.Property
On Error GoTo ErrSetKey
If CurrentDb.Properties("AllowBypassKey&quot.Value Then
CurrentDb.Properties("AllowBypassKey&quot.Value = False
Exit Sub
End If
If InputBox("Enter password to gain access to database window&quot = "WhateverPasswordYouWant" Then
Answer = True
Else
Answer = False
End If
SetProperty:
CurrentDb.Properties("AllowBypassKey&quot = Answer
Exit Sub
ErrSetKey:
Select Case Err
Case 3270
Set myprp = CurrentDb.CreateProperty("AllowBypassKey", dbBoolean, Answer)
CurrentDb.Properties.Append myprp
Exit Sub
Case Else
MsgBox Err.Description
Exit Sub
End Select
End Sub

Change WhateverPasswordYouWant with...you know...whatever password you want...and remember it-it's case sensitive. If you forget it, you'll be back asking how to hack your own work .

Create a button (ButPassword) on your switchboard.
Right click your button, choose Code Builder and paste:

DnDatabaseKey

Save your switchboard form
Open it in Form view
Click the button
Close the database.
Open the database.
You won't be able to access practically anything.
Keeping Shift pressed will have no effect.

To enable Shift:
Open the database.
Click the password button.
Enter the correct password.
Close the database.
Open the database while keeping Shift pressed.
Click the password button again, otherwise the database will be 'unlocked' for any other user that happens to open the database at that time.

However, guys familiar to Access could still hack the disabled Shift...


HTH,
Dan

 

[Laois]

Forget about security and shift keys, just make your db into an MDE file. Users cannot make any design changes to an MDE. Give your users the MDE file and you keep the MDB file. If you need to make changes just make them to the MDB and then create a new MDE file.

Dermot

 

[danvlas]

In mde files users can still delete tables, queries and macros...

Dan

 

[hermanlaksko]

What kind of users R these terroists?
Are they out to get a solution that does ther work for them or what ? I do not understand.
However the solution suggested by danvlas works so if you implement this your users (the terrorists ;-)) will not have access to the database window itself.

 

[danvlas]

To make it stronger, implement it and convert the file to an mde, but keep a copy of the original mdb, otherwise, you'll be trapped in your own cage...


hermanlaksko: users are always terrorists, it's just that they don't know it

Dan

 

[Francescina]

If you want real security you will definitely need to invest some time and effort.
First, read the MS white paper on security and the security related articles in the ACCESS ONline Encyclopedia at

http://www.unsoftwareag.com

(especially about how to secure the backend tables!!!!).
Once you really understand it, activate the security system (FE/BE), check it 2 times, create a double MDW system and install it.
But be aware that your evil users can always delete the MDE/MDB files ;-)

 

[jdegeorge]

Dan

This worked like a charm. Thanks, and enjoy the star!

Jim DeGeorge