If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Database Dumping
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? |
#2
|
|||
|
|||
Database Dumping
Why do you want to do this?
An Access97 database can be 1 Gig and succeeding versions can be 2 Gig. Steve "C#''er" wrote in message ... 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? |
#3
|
|||
|
|||
Database Dumping
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" wrote: Why do you want to do this? An Access97 database can be 1 Gig and succeeding versions can be 2 Gig. Steve "C#''er" wrote in message ... 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? |
#4
|
|||
|
|||
Database Dumping
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" wrote in message ... 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" wrote: Why do you want to do this? An Access97 database can be 1 Gig and succeeding versions can be 2 Gig. Steve "C#''er" wrote in message ... 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? |
#5
|
|||
|
|||
Database Dumping
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" wrote: 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" wrote in message ... 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" wrote: Why do you want to do this? An Access97 database can be 1 Gig and succeeding versions can be 2 Gig. Steve "C#''er" wrote in message ... 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? |
#6
|
|||
|
|||
Database Dumping
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 "C#''er" wrote in message ... 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" wrote: 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" wrote in message ... 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" wrote: Why do you want to do this? An Access97 database can be 1 Gig and succeeding versions can be 2 Gig. Steve "C#''er" wrote in message ... 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? |
#7
|
|||
|
|||
Database Dumping
On Thu, 14 Aug 2008 11:30:19 -0700, C#''er
wrote: 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. -- John W. Vinson [MVP] |
#8
|
|||
|
|||
Database Dumping
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" wrote in message ... 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? |
#9
|
|||
|
|||
Database Dumping
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" wrote: 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" wrote in message ... 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? |
#10
|
|||
|
|||
Database Dumping
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 "C#''er" wrote in message ... 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" wrote: 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" wrote in message ... 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? |
Thread Tools | |
Display Modes | |
|
|