locked
Copy MS Access Database To A Remote Location RRS feed

  • Question

  • User1171172248 posted

    Hello,

    I have a database (data.mdb) on Server A. I want to copy/duplicate the whole database to a remote Server B. I want to do this thing at button click. I dont want the user to manually upload file. At button click data.mdb should get copied to Server B. I am using C# & asp.net.

    Regards

    Tuesday, June 3, 2014 4:01 AM

Answers

  • User-821857111 posted

    You need to put something on server B that will manage this. That could be an FTP site or if the database is small enough, you could use HTTP to POST the file. Or you might be able to create a Web Service that accepts a byte array and call that.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 3, 2014 7:29 AM
  • User-821857111 posted

    No. You can use the WebClient class to "upload" the mdb file: http://msdn.microsoft.com/en-GB/library/ms144229.aspx

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 3, 2014 8:28 AM

All replies

  • User-821857111 posted

    You need to put something on server B that will manage this. That could be an FTP site or if the database is small enough, you could use HTTP to POST the file. Or you might be able to create a Web Service that accepts a byte array and call that.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 3, 2014 7:29 AM
  • User1171172248 posted

    How can i use HTTP to Post the file, will it be like a mail.

    Tuesday, June 3, 2014 8:10 AM
  • User-821857111 posted

    No. You can use the WebClient class to "upload" the mdb file: http://msdn.microsoft.com/en-GB/library/ms144229.aspx

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, June 3, 2014 8:28 AM