backing up and updating ".mdb" file

Results 1 to 2 of 2

Thread: backing up and updating ".mdb" file

  1. #1
    Join Date
    Dec 1969

    Default backing up and updating ".mdb" file

    I would like to update a ".mdb" file. Basically, im uploading a new database to the server to replace the existing database. My problem is, how can i manage this without cutting service? I know that i can use the "Insert Into" with Access, however, im worried this function will not work if the structure of the new updated database is different from the existing database. What is the easiest way to go about doing this without cutting service. Any useful links would be good too. Thanks.

  2. #2
    MG Guest

    Default RE: backing up and updating

    Many ways<BR>Create ASP pages with forms that update the data and create new data. This could be a big project depending on your expertise and the number of tables.<BR><BR>A better Way<BR>Upgrade to SQL server and use Enterprise Manager to update manage the database. You are able to design, update, append, etc without taking the database down. It keeps running.

Posting Permissions

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