none
Is it possible? RRS feed

Answers

  • Hi LibraryTechChik,

    For your requirement, I think there are two ways, one is to copy the entire Access 2010 database file to different server, and another way you could use Application.CompactRepair method.

    For Application.CompactRepair method, you could refer the link below:
    # Application.CompactRepair Method (Access)
    https://msdn.microsoft.com/EN-US/library/office/ff193242.aspx

    Based on your description, it seems your target path would not work. I suggest you check whether you could manually copy the file, and check the server path whether it is correct.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Thursday, November 5, 2015 6:11 AM

All replies

  • Hi. I don't see why not as long as you have access to the servers on your network. What have you tried?
    Wednesday, November 4, 2015 1:32 PM
  • Hi. I don't see why not as long as you have access to the servers on your network. What have you tried?

    I tried writing a vba script, but it doesn't like the path.

    "A computer lets you make more mistakes faster than any invention in human history -- with the possible exceptions of hand guns and tequila." Mitch Ratliffe

    Wednesday, November 4, 2015 1:32 PM
  • Hi LibraryTechChik,

    For your requirement, I think there are two ways, one is to copy the entire Access 2010 database file to different server, and another way you could use Application.CompactRepair method.

    For Application.CompactRepair method, you could refer the link below:
    # Application.CompactRepair Method (Access)
    https://msdn.microsoft.com/EN-US/library/office/ff193242.aspx

    Based on your description, it seems your target path would not work. I suggest you check whether you could manually copy the file, and check the server path whether it is correct.

    Best Regards,

    Edward


    We are trying to better understand customer views on social support experience, so your participation in this interview project would be greatly appreciated if you have time. Thanks for helping make community forums a great place.
    Click HERE to participate the survey.


    Thursday, November 5, 2015 6:11 AM
  • Would you mind showing us the code  you created?
    Thursday, November 5, 2015 6:31 AM