Backup DB Objects and Not Use Sign On Security of non Admin User

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way to routinely back up the objects in my mdb (perhaps writing
all of the objects out to an external mdb that is named ‘backup’) that does
not look at the security of who is currently signed on?
 
Hi, Lewis.
Is there a way to routinely back up the objects in my mdb (perhaps writing
all of the objects out to an external mdb that is named ‘backup’) that does
not look at the security of who is currently signed on?
Click to expand...

Yes. Two ways:

1.) Use the operating system to copy the entire database file to a backup
location. Ensure that Windows security allows copying of files from the
source directory to the destination directory, i.e., read permissions on the
source directory and read/write permissions on the destination directory.

2.) Provide the credentials programmatically for a member of the Admins
group, then conduct the backup as that member.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
 
Thanks. I will give it a try.

'69 Camaro said:
Hi, Lewis.


Yes. Two ways:

1.) Use the operating system to copy the entire database file to a backup
location. Ensure that Windows security allows copying of files from the
source directory to the destination directory, i.e., read permissions on the
source directory and read/write permissions on the destination directory.

2.) Provide the credentials programmatically for a member of the Admins
group, then conduct the backup as that member.

HTH.
Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
Blog: http://DataDevilDog.BlogSpot.com
http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.
Click to expand...
 
Back
Top