backup data base @ 100mb OF MDB

[balu]

can any one please advise how to do this
on cmd click how to backup the access database
to an perticular address and name while
(1) on my choice
(2) on when ever my MDB file reaches the size of 50mb or more automatically
kindly advise

 

[John W. Vinson]

can any one please advise how to do this
on cmd click how to backup the access database
to an perticular address and name while
(1) on my choice
(2) on when ever my MDB file reaches the size of 50mb or more automatically
kindly advise

It's a bit difficult to back up a .mdb file *from within that mdb file*. It
can be done with some code, but it's much easier to just use Windows tools or
your favorite backup software to back up the entire database file, at some
point when nobody is using it.

I have NO trace of a notion what you mean by "a particular address" - a
specific folder or disk???

50 Mbyte is a very modest size for a database. You're limited to 2048 MByte,
and 500 MByte is still very managable. You should of course have it backed up
at all times, and you should also periodically use Tools... Database
Utilities... Compact and Repair to free up waste space; it is probably not
advisable to use the Compact on Close feature although it can be useful in
some cases.

 

[balu]

sir ,
is it possible to backup the backend from the front end of data base ( on
splitting)
to an perticular drive & directory
exactly i m trying to get some code which can create & well ofcourse compact
the data base when ever the size of my mdb backend => xx mb or xx gb
because of data inflow rate to the data base is considerably more so as the
precaution i wnat to back up the whole database and then run an delete query
at the choice the user who can delete some record sets to reduse the size .
how to do it from frontend please.