How to share a Microsoft Access database over the Internet

By Your Office Anywhere

28 Jul 2015

How do you share a Microsoft Access 2013 database using the Cloud?

By YourOfficeAnywhere.

You’ve developed a Microsoft Access Database to help run your business or charity but as your organisation grows you want to share it with colleagues or employees. You may also want to share it with colleagues at other branches or with remote workers or volunteers, maybe you need to run it from home, or from a customer’s office. Hold on! It’s starting to sound complicated, and complicated is expensive, right?

Not necessarily.

There are several ways you can share your Access database, and theMicrosoft Access Database to the Cloud right method for you will depend on your individual circumstances and needs. There are many articles about this on the Web, so no need to repeat them here.This article discusses how you can host Microsoft Access using the Cloud for the lowest cost, without having to make major code changes to your database.

First off a quick mention about licences. Microsoft licence Access as part of Office Professional or you can get it as a standalone product; and you could provide it to all your users for them to run Access – getting expensive again! However, Microsoft also provides a FREE Runtime version of Access, meaning no licences required for most of your users.

To use Runtime you need to split your database, reorganising it into two files. At the backend you have the database tables and at the front end all the other objects such as forms, reports, and queries. Each user has their own copy of the Runtime front-end database all connecting to the same backend database. Splitting the database is straightforward, and again there are many articles about it online.

So, where do you put the database so everyone can share it? This is where the beauty of The Cloud comes in to play. A Cloud Hosted Desktop provider will give you your own dedicated server sat on high spec infrastructure in an ultra-secure data centre, supported, backed-up and maintained by the provider. The database and Runtime files are installed on the server and using technology from Microsoft called Terminal Services all anyone needs to run your shared Access database is an Internet connection on their device, and it can be almost any device, Windows, Mac, iPad or Android.

Each user has an icon on their desktop for the application, but the application actually runs on the hosted server. The only thing that comes up and down the Internet are the screen refreshes, mouse clicks and keyboard presses; so many users can run the application on an average broadband connection. Did I mention they can run it from anywhere there is Internet access?

So you can have as many of your users as you like from all different sites running your Access database application, you don’t need any infrastructure on site beyond a broadband connection. You don’t need to recode the application or have complicated network arrangements. In fact there is no capital investment required at all only a low monthly operating cost to pay for the hosting services. Your Office Anywhere are one of the UKs longest established Cloud hosting provider and have many customers and developers using Access on their platform with prices starting from as low as £19.10 per user per month. For more information or to request a free trial contact their technical sales team on 01282 500318 or email [email protected] and we’ll call you straight back.

Enjoyed this? Read more from Your Office Anywhere

Latest news

1

Partner promotions at WNJ Stuart Mercer, left, and Matthew Johnson

Partner promotions at WNJ

21 May 2025

2

Accrington-made Vita Advanced Mattress wins prestigious 'Best of the Best' Award at Interzum 2025 Dr. Emily Schweissinger - Evonik, Dr. Roland Hubel - Evonik, Dr Mike Murray - The Vita Group, Natalie Watson - The Vita Group, Chris Hupfeld - Coverstro, Dr. Annegret Terheiden - Evonik and Dennis Wagner - Covestro

Accrington-made Vita Advanced Mattress wins prestigious 'Best of the Best' Award at Interzum 2025

21 May 2025

3

Napthens advises Calico Homes on land acquisition for £23m Dovestone Gardens extra care facility in Burnley Paul Hardy

Napthens advises Calico Homes on land acquisition for £23m Dovestone Gardens extra care facility in Burnley

21 May 2025

4

Construction begins on new Civil Service office building in Talbot Gateway Alan McBride Muse Will Town Defence Infrastructure Organisation Jennifer Chard Defence Business Services Cllr Lynn Williams Blackpool Council Garry Bowker Vinci

Construction begins on new Civil Service office building in Talbot Gateway

20 May 2025

5

Skiddle raises over £750,000 for charities Skiddle cheque presentation to Alder Hey Hospital

Skiddle raises over £750,000 for charities

20 May 2025

Background image for hub sign up block

LBV Hub

Leverage Lancashire Business View platforms

Post your news
Post your events
Post your offers
Build your network
Improve your SEO
Gain coverage in the magazine
Sign-up
Events
Sub36 Networking
Networking
11 Jun 2025

Sub36 Networking

British Jewellery School, Scorton, PR3 1BA

15:00 - 17:00

Lancashire Net Zero Carbon Conference
Net Zero Carbon Social 1200pxtrident 2
Networking
18 Jun 2025

Lancashire Net Zero Carbon Conference

Crow Wood Hotel & Spa Resort, Burnley, BB12 0RT

08:30 - 13:00

Lancashire Built Environment Conference 2025
BEC 315 X 315 Px
Networking
25 Sep 2025

Lancashire Built Environment Conference 2025

Blackpool Football Club, Blackpool, FY1 6HX

08:30 - 13:00

CMI Level 5 Management and Leadership Course
UCLanAerialCampus.jpg.jpg
LBV Hub Seminars
21 Feb 2025 - 21 Feb 2026

CMI Level 5 Management and Leadership Course

Preston Campus, Preston , PR1 2HE

09:00 - 17:00

CMI Level 5 Project Management Course
UCLanAerialCampus.jpg.jpg
LBV Hub Seminars
21 Feb 2025 - 21 Feb 2026

CMI Level 5 Project Management Course

Preston Campus, Preston, PR1 2HE

08:00 - 17:00

RISE - The Academy for Female Leaders and Managers
WENDY BOWERS RISE Illustrstion copy.jpg.jpg
LBV Hub Seminars
02 Apr 2025 - 08 Oct 2025

RISE - The Academy for Female Leaders and Managers

East Lancashire Chamber of Commerce, Clayton le Moors, BB5 5JR

09:00 - 15:30

Preston Freelancer Meet-Up: May
Freelancer Meet-Up May.png.png
LBV Hub Networking
22 May 2025 - 22 May 2025

Preston Freelancer Meet-Up: May

society1, Coworking Space, Preston, PR1 3LT

10:00 - 11:30

Amber River True Bearing quarterly investment seminar
LBV Hub Seminars
22 May 2025 - 22 May 2025

Amber River True Bearing quarterly investment seminar

Cottons Hotel & Spa , Knutsford, WA16 0SU

16:00 - 18:00

The Business Network Central & East Lancashire
LBV Hub Networking
22 May 2025 - 22 May 2025

The Business Network Central & East Lancashire

Mytton Fold, Langho, BB6 8AB

11:30 - 14:15

Liverpool Business Expo 2025
https---cdn.evbuc.com-images-881365363-4862066883-1-original.20241023-085714.jpeg.jpg
LBV Hub Awards
23 May 2025 - 23 May 2025

Liverpool Business Expo 2025

Aintree Racecourse , Liverpool , L9 5AS

09:00 - 15:00

Advantage: AI – A Workshop for Business Leaders – May 29
Artboard 15.png.png
LBV Hub Seminars
29 May 2025 - 29 May 2025

Advantage: AI – A Workshop for Business Leaders – May 29

Door4 Office, Burnley Wharf, Manchester Road, Burnley, BB11 1JG

09:00 - 11:00

Business Bike Club – June
Chamber Logo1.png.png
LBV Hub Networking
03 Jun 2025 - 03 Jun 2025

Business Bike Club – June

Various, Lancaster, LA

08:00 - 09:30

Advertise with us

Reaching 50,000 members, our print, digital and event platforms offer a fantastic way to raise your business profile and help you grow.

Find out more LBV122 Online Graphic
Subscribe now

Weekly news bulletin