Share via

Microsoft Access Database hosted in the cloud

Anonymous
2021-03-06T22:33:46+00:00

I have a local.desktop application built on  microsoft Access database. I want to host this on a cloud server using a multitenet setup.

  1. Can this be done?
  2. If so, what is needed to convert my application to a cloud database.

 3. If this cant be done, then what is my best option? What tools to create my database design for server hosting using microsoft?

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-03-07T12:26:36+00:00

    Access cannot be hosted in the cloud.

    What can be done is:

    • Migrate the data to Azure SQL and link to it, but this can require reworking your forms, reports, to minimize the data being pushed and pulled to avoid all SELECT * .... No matter what you do, such a hybrid database will result in a reduction in performance.
    • Use technologies such as:
    1. Citrix
    2. Terminal services
    3. RDP/TeamViewer
    4. ...
    • Host your database on a service such as accesshosting.com (I have no affiliation and there are other providers you can choose from)

    But truthfully, if web deployment is your goal, then this should have been part of your project specifications in which case Access would not have been the tool to use from the start. For such a need, you are always best using proper web technologies (PHP, . net, ...). It can take some work to do, but in my experience the benefits are well worth it.

    9 people found this answer helpful.
    0 comments