Trying to create backup from within the database

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.
 
A

Alex White

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.
 
J

Jesper Fjølner

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.
 
Top