none
Multiple users and Access compatibility question? RRS feed

  • Question

  • Is there an ability for Access users to utlitze same database in conjuction at multiple locations at the same time?  I have several offices throughout the country, and would like my management and IT technicians to have the ability to work together on projects regardless of where they are in the country at any particular moment. Any help would be greatly appreciated.  Thank you.
    Tuesday, November 19, 2013 7:20 PM

Answers

  • Possibily, but unlikely to work if you have a slow network between offices or the file will be large, or you have many concurrent connections. Better to use SQL Server.


    Visual C++ MVP

    Wednesday, November 20, 2013 1:01 AM
  • Hello hotnail97,

    It is possible to connect to a remote Microsoft Access database from Active Server Pages on an IIS Web server. To do this, we need to set up the connection string just as we would if the database were on the local server as described in the "References" section of this article. However, when the database is on a remote server, there are a number of additional configuration steps that should be taken to ensure that this works correctly.

    For the details information, please have a check link below:

    http://support.microsoft.com/kb/253580

    As said by Sheng Jiang, it is better to use SQLServer actually.

    Regards.


    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 21, 2013 6:45 AM
    Moderator

All replies

  • Possibily, but unlikely to work if you have a slow network between offices or the file will be large, or you have many concurrent connections. Better to use SQL Server.


    Visual C++ MVP

    Wednesday, November 20, 2013 1:01 AM
  • Hello hotnail97,

    It is possible to connect to a remote Microsoft Access database from Active Server Pages on an IIS Web server. To do this, we need to set up the connection string just as we would if the database were on the local server as described in the "References" section of this article. However, when the database is on a remote server, there are a number of additional configuration steps that should be taken to ensure that this works correctly.

    For the details information, please have a check link below:

    http://support.microsoft.com/kb/253580

    As said by Sheng Jiang, it is better to use SQLServer actually.

    Regards.


    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 21, 2013 6:45 AM
    Moderator