How do I secure the physical DB?

[Vince]

Hi,

I am creating an application via Accesss 97 and running
the engine on the users desktop and linking the table
found on a network drive.

Example:
X:\Administration\DB.mdb (MAIN TABLE)

Now they have login scripts that map X:


MY PROBLEM:
Users can now just go to the directory mentioned above and
DELETE the ENTIRE TABLE or MODIFY DATA!!!!

What is the best way? Will securing the data via MS
Access security enable me to lock down this DB?

Basic PW protection can be cracked easily.

Please suggest.

Thank YOu.

 

[Immanuel Sibero]

Hi Vince,

Access database is a file based system (as opposed to client/server). As
such, all users must have full rights to the file and folder in which the
mdb file resides. No way around this. Two of Access' security
features -database password, - user level security would not 'physically'
secure the file. You would need to move to client/server based application
such as SQL server to do what you want.

If you have a front end and link to a backend Access mdb. I guess, you could
put the back end mdb in a network share folder which your users do not map
to. Users must still have full rights to that folder but they would not have
a mapped drive to the folder. You would need to link your tables using UNC.


HTH,
Immanuel Sibero