Question Lock the "Project" file from users ?

thaicoon

New member
Local time
Today, 16:50
Joined
Nov 27, 2008
Messages
6
I need help :(
we just established the access project on our server stored in the hidding location, we set the password for all users restricted them from various of tables and forms.
We set the startup form and hiding the normal menu.

My questions are ;
1. If user press the 'shift' button during open the program , the menu still come out and all tables / forms shall be access via the database. how to protect this ?
2. even we set the password of SQL server , some users still able to go to that directory and copy the "ADP" files out to their PC. and they can open it. I think that we can't protect them from copying , but at least , if they can't open it out - it would help. How to ??
We are small company and is a 'new' for database on server , it's not like once I used normal access file which I can customized the users and passwords and protect the database. I have no idea how to do that in 'ADP' files.

Please advise me , Cheers,:confused:
 
You can set the BypassShiftKey proeprty to false to prevent users from preventing the load protocol you have in place. You can also make an MDE from the MDB and use that instead. I assume you have split the database into a front end - back end setup. With the interface on each users machine pointing to the backend data source on the server. You can set a password on the backend database that will prevent outsiders from seing the data, whether it has been copied elsewhere or in its current location.

Do a search on securing a database in this forum there are plenty of topics.

David
 
Thank you Dave,
I'm still moving in the circle of this thing, First I tried to make a MDE file but it can't complete the converting. Need to check the compling again.
most of samples I found in the forum are for MDB and it not works on 'project' file.
 

Users who are viewing this thread

Back
Top Bottom