B
bondtk
I've been thinking this one over for a while and know there must be some way
to accomplish this. I am trying to create a way to have the daily data
entered into my database saved/exported/appended to an outside source for
safe keeping in the event that my database becomes corrupted and won't open.
This just happened today on a smaller scale as the .ldb lock file must have
gotten messed up which then wouldn't allow me to open my database or even run
the repair function until I read on here to rename the .ldb file and then run
the repair. Worked great and everything was fine. wheh!!
But what would be nice is an Excel file that has a copy of every entry from
my one main table that would be exported from the database as it is entered.
Then, if something did happen, I could (in theory) easily import the Excel
file into my daily backup of the database without missing any information.
(I do have a .bat file that runs each morning I turn on my computer to grab a
copy of the datbase's back end from the server and copy it to my hard drive.
Our company also makes backups of the server but I need a quick, reliable
source without having to call IT and holding up our entire department). Is
there any code that could do this.
Or maybe the idea might be to have another, differnt database where each
record from the main table can be copied to as a backup source. It could
keep an identical copy of the records. I'm not sure which method would be
best. I haven't seen any posts on how to accomplish this.
The idea is a pretty simple but I really would feel more comfortable if I
knew that each record was being sent to an alternate source. I've worked
very hard on this new database system and would hate to have it crash and
loose at least a day's worth of data (which wouldn't be the end of the world
but might be tricky to know which items needed to be entered if there was a
corruption problem). Any ideas or code would be appreciated!!
to accomplish this. I am trying to create a way to have the daily data
entered into my database saved/exported/appended to an outside source for
safe keeping in the event that my database becomes corrupted and won't open.
This just happened today on a smaller scale as the .ldb lock file must have
gotten messed up which then wouldn't allow me to open my database or even run
the repair function until I read on here to rename the .ldb file and then run
the repair. Worked great and everything was fine. wheh!!
But what would be nice is an Excel file that has a copy of every entry from
my one main table that would be exported from the database as it is entered.
Then, if something did happen, I could (in theory) easily import the Excel
file into my daily backup of the database without missing any information.
(I do have a .bat file that runs each morning I turn on my computer to grab a
copy of the datbase's back end from the server and copy it to my hard drive.
Our company also makes backups of the server but I need a quick, reliable
source without having to call IT and holding up our entire department). Is
there any code that could do this.
Or maybe the idea might be to have another, differnt database where each
record from the main table can be copied to as a backup source. It could
keep an identical copy of the records. I'm not sure which method would be
best. I haven't seen any posts on how to accomplish this.
The idea is a pretty simple but I really would feel more comfortable if I
knew that each record was being sent to an alternate source. I've worked
very hard on this new database system and would hate to have it crash and
loose at least a day's worth of data (which wouldn't be the end of the world
but might be tricky to know which items needed to be entered if there was a
corruption problem). Any ideas or code would be appreciated!!