[AccessD] Database Security

Hi Gregg

If this is Access 97 you may look up in the archives from 2002-10-01:

  A97 database password

It's quick to set and with the speed of today's machines the users
wouldn't note any difference.

Of course, if the users are allowed to copy files you will need to
move the data off a file which the users can locate. This can be done
by using an SQL engine, moving your app to a terminal server, or I
guess (haven't tried and it may perform too slowly) by opening an
Access database on a remote machine which has attached tables from a
third machine where users cannot log in ...

/gustav


> Is there some magical way to keep an employee from burning a copy of the
> database to a CD?  The customer does not want to restrict use of CD burning
> so...

> if not....

> is there a way to encrypt the database with a password?  I see the user
> level security will encrypt it for those users but I would rather not have
> the hassles of turning that on.  If I could encrypt with a password that I
> could pass through in code, I wouldn't worry if anyone took it.

> if not....

> is SQL a better answer?

> Gregg Steinbrenner