Post reply

Copy mdb''s when connection is open

  • April 9, 2007 at 7:08 am

    #171964

    Hello,  we have a case where a purchased software product uses a MS-Access database and an open connection is established when the service starts.  The application runs 24x7 and we need to copy the MDB files once a day.  The program establishes only a connection and does not write, update or do any inserts except at 1:00 am.  We need to copy the fileslet's say at around 2pm after the nightly update runs.  Is there any software out there that can perform this? thanks!

  • April 9, 2007 at 8:51 am

    #699306

    Doesn't the Windows XCOPY cope with the open file?

    The alternative would be

    NET STOP YourService

    XCOPY drive.spec\*.MDB drive:spec

    NET START yourService.

    Down time should be pretty short.

    LinkedIn Profile

  • April 11, 2007 at 10:14 pm

    #699959

    I would have thought downtime would be dependent on the size of the MDB file and the speed of the network & drives.

    And as there's capacity to have a 2Gb database (I hope you don't as it's about to fall over) then there's chance that it could be quite a time - though not overly long in fairness I suppose.

    I'm assuming that it's to do with backing up the data...

    As such, why not create a new database and link link into the tables on the one that's 'up' then you can use the slave to copy your data down to your own database, and do with it as you wish.

    You could even impliment some reporting off that database (and it's now local tables) - reducing the loading on your 'live' server.

    Care is needed in how you query the data though, as you could lock the tables as you go (use a snapshot query, and update a copy of the table structure), and of course things are possibly going to go slow whilst you're doing this.

    Oh, and beware if you're copying table structures for making backups that you don't copy the autonumber fields as autonumber, make them standard number fields or you're going to have a heap big problem should you ever use the data.

    Hope some of that helps!

     

  • April 16, 2007 at 8:55 am

    #700705

    Thank you, you have been helpful.

     

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply