Access database secured across network

[Tory]

Hi,

I have an Access database that needs to be secured and I have 2 problems:

1) How do I get it across a network so all users must enter their password?

2) How do I stop this from asking for a password for every database (i.e. I only want one database to require the password)?

Please keep answers simple as I am quite new to this!!

 

[Guus2005]

create a workgroup (MDW) file using the workgroupadministrator
when deploying your database also send this MDW file.

Search this forum for "security" it will give you lots of starting points.

 

[Oldsoftboss]

Search this forum for "security" it will give you lots of starting points.

And read, read, read, and make backup copies of your Db's

Many efforts to secure database have been completely screwed (including myself - I gave up in the end) and locking yourself out of all your databases.

Keep us posted.

 

[Tory]

Still not working

I can get to a workgroup file and change the Admin etc but it wont allow me to change permissions as Engine owns everything!

 

[Guus2005]

How do you open your "protected" database?
Is it something like this?

Shortcut contents:

msaccess /wrkgrp yourmdwfile.mdw yourFEdatabase.mdb
or
msaccess /wrkgrp yourmdwfile.mdw yourFEdatabase.mde

Simply clicking the database triggers the default system.mdw workgroup file.

 

[Tory]

Now have it working though it seems to now want a password and username for any database I open!

 

[Guus2005]

Simply clicking the database triggers the default system.mdw workgroup file.

It seems that you have overwritten the default system.mdw file. Restore it and try again.

Check all other databases if you can start them.

Create you own system workgroup file.
Save it in a different name. Don't use system.mdw but mysystem.mdw instead. (or whatever)
Store it in the directory where your frontend database resides.

You can start your database using the following shortcut:

<your path>\msaccess.exe /wrkgrp mysystem.mdw yourFEdatabase.mdb

When you have done this, you can set the Admin password and start creating groups and users.

 

[Simon_MT]

There is a point where you have to ask what you are trying to acheive with security.
The first thing I do is protect the frontier VPN etc so any issues are local. We also need a database that is fully portable, it can be transferred to laptops.

I ended up just identifying the user from Environ$('UserName') which is then embedded into the Employees table. This table also includes a Status and it is this that can be used to control events.

This may sound too relaxed for some people but if you putting information into a database it only has one purpose - to be used.

Simon