Moving Secure Database

[Ripper]

I created a secure database backend while working on my home computer. Took
a while and several attempts to get it right. Now how do I move it to the
server where it must reside? Unsecure databases are easy as pie to move.
You copy the file and paste it to the server.

Also, if I secured the backend, do I need to secure the frontend as well?

 

[Rick Brandt]

I created a secure database backend while working on my home
computer. Took a while and several attempts to get it right. Now
how do I move it to the server where it must reside? Unsecure
databases are easy as pie to move. You copy the file and paste it to
the server.

Also, if I secured the backend, do I need to secure the frontend as
well?

There is nothing different about moving a secured file over a non-secured
one. If you encounter differences it might mean that you didn't actually
apply security properly.

Security is more concerned about the location of the workgroup file. The
location of the MDB/MDE is not an issue.

Now, if you are launching your secured file via a shortcut that specifies
the location of the workgroup file as well as the file to open then that
shortcut will certainly "care" if you move either one of the files it
references, but I can think of no other ramifications.

 

[Tom van Stiphout]

On Thu, 27 Mar 2008 12:41:00 -0700, Ripper

Your posting seems to indicate that you're unclear about the finer
points of workgroup security. That's a problem, because it is an
advanced topic. You should download, study, and fully understand the
Access Security FAQ from microsoft.com before proceeding.
Then there will not be "several attempts" nor unclarity of where the
security needs to be applied.

-Tom.