Trying to create backup from within the database

  • Thread starter Thread starter Jesper Fjølner
  • Start date Start date
J

Jesper Fjølner

I'd like to create a backup function from within a multiuser database and
I'm aware that everyone should be out of it before doing it. If I'm sure I'm
the only one with the fronted open and I have no forms open - is it then
secure to copy the backend file to another location?
I get a backendfile.ldb in the folder everytime I open a form in the
frontend, but when no forms are open in the frontend the backendfile.ldb
dissappears.
I thought of closing all forms and then running a copy of the backendfile
and maybe even a compact-repair.
Can it all be done from within the fe-file or should I just create another
app or db to do this with both the fe and be safely closed?
Thanks.
 
Hi,

The safest method is completely outside of access although it can be
done whilst running in the front-end. The best method is a batch file
that you call, close access, backup the database, then run access again.

Hope it helps

Regards

Alex

Alex White MCSE MCDBA
www.IntraLAN.co.uk


-----Original Message-----
From: Jesper Fjølner [mailto:jf]
Posted At: 24 April 2005 20:49
Posted To: microsoft.public.access.formscoding
Conversation: Trying to create backup from within the database
Subject: Trying to create backup from within the database

I'd like to create a backup function from within a multiuser database
and
I'm aware that everyone should be out of it before doing it. If I'm sure
I'm
the only one with the fronted open and I have no forms open - is it then
secure to copy the backend file to another location?
I get a backendfile.ldb in the folder everytime I open a form in the
frontend, but when no forms are open in the frontend the backendfile.ldb
dissappears.
I thought of closing all forms and then running a copy of the
backendfile
and maybe even a compact-repair.
Can it all be done from within the fe-file or should I just create
another
app or db to do this with both the fe and be safely closed?
Thanks.
 
The safest method is completely outside of access although it can be
done whilst running in the front-end. The best method is a batch file
that you call, close access, backup the database, then run access again.
Click to expand...

Ok, thanks.
 
Back
Top