Database Dumping

[C#''er]

Is there a way I can have my BE Database periodically dump all its
information into an excel spreadsheet, or better yet, another access DB?

 

[Steve]

Why do you want to do this?

An Access97 database can be 1 Gig and succeeding versions can be 2 Gig.

Steve

 

[C#''er]

Well, id like for the information to be dumped so others can use it and not
affect the design of the database. From my expierence with my co-workers, ive
learned that Murphy's Law is real. Also I have to prepare for possibly some
not so saavy computer users.

 

[Steve]

Sorry, I'm still unclear as to why you feel you need to dump the data.
Please explain what you think on how others can affect the design of your
database by using the information. Also please explain your concern about
"not so savvy xomputer users" using your information.

Steve

 

[C#''er]

I’m sorry; maybe it’s my use of the word 'dump'. Id like to have the
information auto-export to either another access file, or an excel file.
Would a macro suffice? And by “not so computer savvyâ€....I meant computer
illiterate. A few months ago, I was gone one day. When I got back to work,
tons of data was lost. Basically, I want to back-up the data. But I want to
be able to be out one day and not have to worry about loosing data.

 

[Steve]

If all you are looking for is to back up your BE, then use Windows Explorer
and make a copy of the BE. If a problem arises, you will always be able to
delete the problem BE and restore the copy.

Steve

 

[John W. Vinson]

Basically, I want to back-up the data

Then back up the database, by making a copy of the entire .mdb (or other
format) file. You can do so using Windows Explorer or Windows Scheduler,
unattended. Be sure you do so at a time when the database is not being used; a
backup made while data is being updated is suspect.

 

[Jeff Boyce]

Your mileage may vary ... in my shop, the network gurus have an automated
backup routine backing up files on the LAN.

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[C#''er]

Jeff, thats more along the lines of what I am looking for. Its not a problem
to just make a copy of the file. The problem is more "How can this file (or
data) be backed up or copied if I am not here?" I have decided to hide the
actual database file just so no one can mistakenly delete it (trust me,
around here--it happens).

 

[Jeff Boyce]

A somewhat tongue-in-cheek solution might be to tell folks "if you break it,
you bought it!" (you'd have to get your boss to agree to fire them, unless,
of course, it is your boss...?!)

Good luck!

Jeff