Back up front end database with security

  • Thread starter Thread starter am
  • Start date Start date
A

am

Hello,

I have splited my database creating a front end and back end. all of my
queries, forms, reports are on the front end. I have created a workgroup
assigned users with there passwords and with there various rights. My
question is how can I make a back up on my front-end in case the front-end
or the secutiry is somehow corrupted.. I am not sure if I can copy the
front-end with the security, I may corrupt the whole database or the
security may not worked. All I want to do is make daily/weekly backup of
the front-end without recreating/re-implentmenting security. Any tips or
website to visit will be appreciated. Thank you in advance.
 
Why do you need a regular backup of the /front/ end? Don't you mean the
/back/ end? The back end is where the user's data is stored.

It's quite safe to take a copy of either or both files, as long as
*no-one has either one of those files open*. If someone *does* have
either or both of those files open, you can still take a copy of them,
but those copies might not work correctly when you try to restore them!

As for the security, you could take a copy of the workgroup (mdw) file,
under the same restrictions noted above. Or better - write down all the
information that you used when you created the workgroup file, then you
can create a new one with that information if the old one becomes
corrupt.

HTH,
TC (MVP Access)
http://tc2.atspace.com
 
am said:
Hello,

I have splited my database creating a front end and back end. all of my
queries, forms, reports are on the front end. I have created a workgroup
assigned users with there passwords and with there various rights. My
question is how can I make a back up on my front-end in case the
front-end
or the secutiry is somehow corrupted.. I am not sure if I can copy the
front-end with the security, I may corrupt the whole database or the
security may not worked. All I want to do is make daily/weekly backup of
the front-end without recreating/re-implentmenting security. Any tips or
website to visit will be appreciated. Thank you in advance.
Click to expand...

I think you might have things back-to-front here - the classic developer's
scenario is to have a development copy of the FE in a private area which you
would then deploy to your users whenever necessary. You can back up your
development copy whenever you like because you'd be the only person ever to
have it open.

HTH - Keith.
www.keithwilby.com
 
Back
Top