Making Access Database Online

%3CLINGO-SUB%20id%3D%22lingo-sub-2351996%22%20slang%3D%22en-US%22%3EMaking%20Access%20Database%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2351996%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20my%20database%20to%20work%20like%20MS%20Excel%20where%20multiple%20users%20can%20view%20and%20edit%20the%20file%20simultaneously.%20Does%20anyone%20have%20any%20suggestions%20on%20how%20I%20can%20go%20about%20this%3F%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advance.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2351996%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3E2013%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EAccess%20Web%20Database%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2352661%22%20slang%3D%22en-US%22%3ERe%3A%20Making%20Access%20Database%20Online%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2352661%22%20slang%3D%22en-US%22%3EAccess%20is%20works%20with%20multiple%20users.%20To%20do%20so%2C%20the%20database%20is%20split%20with%20all%20tables%20stored%20on%20the%20local%20area%20network%20in%20a%20shared%20backend%20file.%20All%20other%20database%20objects%20(queries%2C%20forms%2C%20reports%2C%20macros%2C%20modules)%20are%20stored%20in%20a%20front%20end%20database%20which%20has%20the%20backend%20tables%20LINKED%20to%20it.%20Each%20user%20needs%20their%20own%20copy%20of%20the%20frontend%20database%20on%20their%20own%20workstation%20(not%20in%20the%20network).%3CBR%20%2F%3E%3CBR%20%2F%3ESo%20far%20so%20good...%3CBR%20%2F%3EHowever%2C%20your%20thread%20title%20mentions%20the%20database%20being%20ONLINE.%3CBR%20%2F%3EAccess%20files%20do%20NOT%20work%20over%20the%20internet%20or%20a%20wide%20ara%20network.%20If%20online%20usage%20is%20required%2C%20you%20will%20either%20need%20to%20use%20a%20remote%20desktop%20connection%20or%20similar%20such%20as%20Citrix%20OR%20place%20the%20backend%20in%20an%20online%20environment%20such%20as%20SQL%20Azure.%3CBR%20%2F%3E%3CBR%20%2F%3EPlease%20clarify%20your%20exact%20needs%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hi all, 

I want my database to work like MS Excel where multiple users can view and edit the file simultaneously. Does anyone have any suggestions on how I can go about this? 

Thank you in advance.

1 Reply
Access is works with multiple users. To do so, the database is split with all tables stored on the local area network in a shared backend file. All other database objects (queries, forms, reports, macros, modules) are stored in a front end database which has the backend tables LINKED to it. Each user needs their own copy of the frontend database on their own workstation (not in the network).

So far so good...
However, your thread title mentions the database being ONLINE.
Access files do NOT work over the internet or a wide ara network. If online usage is required, you will either need to use a remote desktop connection or similar such as Citrix OR place the backend in an online environment such as SQL Azure.

Please clarify your exact needs