Embedding a database

[chunk22]

More of a misc question? I have a database that I want to role out to staff and have a few security issues. I would like to know if anyone knows of a program (Free or licenced) that can be used to embed my db so that the back end is not accessable apart from an administrator. Can anyone help?

 

[lupins46]

You could put an autoexec macro in the backend which displays an 'unauthorised access' message and closes the database if it is opened directly. Not 'secure' in any real sense but stops the less-knowledgable.

 

[ZmrAbdulla]

Why don't use Userlevel security?

Zameer Abdulla
Visit Me (New Look & style)

 

[chunk22]

The only thing is with the userlevel stuff,if you manage to find the wif file and delete it it then uses the default file with no locks, has anyone got anything else?

Chunk22

 

[lupins46]

The only thing is with the userlevel stuff,if you manage to find the wif file and delete it it then uses the default file with no locks, has anyone got anything else?"

?wif? Access uses a .mdw file for user name and passwords.
If the mdw file is missing and you have set up security correctly then no-one can get into your database (not even you!)

 

[chunk22]

The wif is the Workgroup information file, when I hade a go at setting up this like I say it works fine but then if you delete this file I could get into the database without logging in. are you saying this is because it was set up incorrectly?

 

[ZmrAbdulla]

More read on Access Security Overview

Zameer Abdulla
Visit Me (New Look & style)

 

[lupins46]

Access security is not a trivial topic and it is easy to take actions which sound like they might be what you want be really do nothing effective.

There is a quite large document here:

http://support.microsoft.com/default.aspx?scid=kb;en-us;207793

It includes a series of steps which are required to secure an application properly.
Do not practice on anything that is not disposable.