Search code examples
databasems-accessms-access-2007collaborationsharing

Access database sharing strategies


What are the strategies you employ to let multiple people work on an access database?

Is it possible to host it online and have its features still functional without having to develop a custom frontend?

MS Access as a software has a few nice features that don't require any programming to configure:

  • Drop down lists - choose one
  • Multi Checkbox lists - choose multiple

Is it possible to get all of these features available even when hosted online? I'm basically thinking of an alternate way to quickly get people to work with data using GUI features like the above without going the webapp<>MySQL way.


Solution

  • One way i've heard of, is to import the access database into a SQL Server database.
    (Almost any version will do.).

    Then link to the SQL Server database with Access and let users use it as they did before.

    Look at this link: http://office.microsoft.com/en-us/access/HA010345991033.aspx

    If you want an online solution i'd recommend going with a normal web application architecture. (Talking to a proper database.).