Best way to protect db

[Juantxu]

Hi,
I have all the data of my clients in Access 2003.
I want my clerk to be able just to enter the data, but not to save, email or export (stealing, in a word) the data.
Obviously, I need full access.
Which is the best way to protect the db?
With the workgroups security thing, as far as I can understand, you are still able to make a copy of the data without being logged as the adm.
Also happened the same using the Logon 2000 code.
What am I doing wrong?
Thank you.

 

[The_Doc_Man]

You want to implement Workgroup security anyway 'cause that's how you can find out what group these people are in. (Always derive rights and permissions from groups, not from individuals.) Once you know that group, you can try to customize the Access toolbar so that, based on who has logged in, certain functions are suppressed. Try searching for topics like customizing tool bars or menu bars.

 

[Sherif Fam]

Hi

there is a way to fully remove the menus and toolbars from the access. It looks like a stand alone application. Use in the shortcut target the following:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" /runtime "\\Dc2\control\Cost Control 01.mde"

Where \\DC2\control\cost control 01.mde is the path to the mde application.

Not sure if this solve the situation.

Take care,
Sherif