Moving Secure Database

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ripper - 27 Mar 2008 20:41 GMT

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?

Signature

Thanks As Always
Rip

Reply to this Message

Rick Brandt - 28 Mar 2008 00:05 GMT

> I created a secure database backend while working on my home
> computer. Took a while and several attempts to get it right. Now
[quoted text clipped - 4 lines]
> 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.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message

Tom van Stiphout - 28 Mar 2008 02:54 GMT

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.

>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?

Reply to this Message