Results 1 to 3 of 3

Thread: [RESOLVED] Table Back-Ups

Threaded View

  1. Apr 20th, 2006, 04:08 AM #1
    MethadoneBoy
    MethadoneBoy is offline

    Thread Starter
    Addicted Member MethadoneBoy's Avatar
    Join Date
    Oct 2001
    Location
    Preferably somewhere between Keira Knightley and Diane Kruger but I'm not fussy
    Posts
    180

    Resolved [RESOLVED] Table Back-Ups

    Hi guys,

    We've an Access database that contains some important financial commission information that I'd like to create a back-up job for. Basically there are several tables in that application with crucial information that we cannot afford to lose. My idea was to simply create a macro that will output these tables to a specific directory on our network. Unfortunately, there are too many rows in each of the tables to export to an Excel spreadsheet (we're using Access 97 and don't have the option of migration to a superior version). Is there any practical way of exporting the data in such a way that, should a catastrophic event causing the tables to be deleted or have their contents wiped occur, this data can be easily read back into the tables? I'd be interested to hear if any of you have had similar issues.

    Thanks in advance.
    Last edited by Hack; Apr 20th, 2006 at 08:14 AM. Reason: Added green "resolved" checkmark Last edited by MethadoneBoy : Today at 08:50 AM. Reason: Resolved
    "'Oh, hello Mr. Crick! What do you think of Jeffrey Archer?' Clip-clip-clip! Oh, come on! Who are you kidding? You wait til I'm mayor, you'll see how tough I am! Christ almighty...."
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width