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 sales@yourofficeanywhere.co.uk and we’ll call you straight back.

Enjoyed this? Read more from Your Office Anywhere

Latest news

1

Supermarket stays put in blow to town's £250m masterplan Blackburn Aerial

Supermarket stays put in blow to town's £250m masterplan

28 Mar 2024

2

Modern Milkman acquires American counterpart article placeholder listing image

Modern Milkman acquires American counterpart

28 Mar 2024

3

How the UK’s strategy to reduce net migration affects care work AdobeStock_89838327 (1).jpeg.jpg

How the UK’s strategy to reduce net migration affects care work

28 Mar 2024

4

Dealmakers: Star Tissue takes a leading roll Khalid Saifullah

Dealmakers: Star Tissue takes a leading roll

28 Mar 2024

5

Construction work begins at 53-home development in Earby article placeholder listing image

Construction work begins at 53-home development in Earby

28 Mar 2024

Hwc 2024 Email Signature 980x120
Background image for hub sign up block

LBV Hub

Reach 50,000 members of the Lancashire business community

Post your news
Post your events
Post your offers
Company profile
Social reach
Magazine coverage
Sign-up
Events
Business Networking in Burnley - BNI Kudos
EVENT LISTING BNI Kudos.png.png
LBV Hub Networking
28 Mar 2024

Business Networking in Burnley - BNI Kudos

Prairie Sports Village, Windemere Avenue, Burnley, BB10 2FU

06:45 - 08:30

Business Networking in Lancaster - BNI Castle
EVENT LISTING BNI Castle.png.png
LBV Hub Networking
28 Mar 2024

Business Networking in Lancaster - BNI Castle

Vale of Lune RUFC, Powder House Lane, Lancaster, LA1 2TT

06:45 - 08:30

Business Networking in Preston - BNI Brunch
EVENT LISTING SIZING Brunch .png.png
LBV Hub Networking
29 Mar 2024

Business Networking in Preston - BNI Brunch

Samlesbury Preston Hotel, Preston New Road, Preston, PR5 0UL

09:30 - 11:00

Business Networking in Blackburn - BNI Infinity
EVENT LISTING BNI Infinity.png.png
LBV Hub Networking
29 Mar 2024

Business Networking in Blackburn - BNI Infinity

Hampton by Hilton, 2 Frontier Ave, Blackburn, BB1 3AL

06:30 - 08:30

Business Networking in Chorley - BNI Endeavour
EVENT LISTING SIZING Endeavour.png.png
LBV Hub Networking
02 Apr 2024

Business Networking in Chorley - BNI Endeavour

Oak Royal, Bury Lane, Chorley, PR6 8SW

06:30 - 08:30

Business Networking in Blackburn - BNI Vista
EVENT LISTING SIZING Vista.png.png
LBV Hub Networking
02 Apr 2024

Business Networking in Blackburn - BNI Vista

Hampton by Hilton, 2 Frontier Ave, Blackburn, BB1 3AL

06:45 - 08:30

Business Networking in Accrington - BNI Zeus
EVENT LISTING SIZING Zeus.png.png
LBV Hub Networking
03 Apr 2024

Business Networking in Accrington - BNI Zeus

The Mill House, Corn Mill Yard, Accrington, BB5 5HX

06:45 - 08:30

Business Networking in Preston - BNI Diamond
EVENT LISTING BNI Diamond.png.png
LBV Hub Networking
03 Apr 2024

Business Networking in Preston - BNI Diamond

The Marriot Hotel, Garstang Road, Broughton, PR3 5JB

07:15 - 09:00

Business Networking in Lancaster - Eden Business Network
EVENT LISTING Eden Business Network.png.png
LBV Hub Networking
03 Apr 2024

Business Networking in Lancaster - Eden Business Network

The Borough, 3 Dalton Square, Lancaster, LA1 1PP

18:30 - 20:30

Business Networking in Burnley - BNI Kudos
EVENT LISTING BNI Kudos.png.png
LBV Hub Networking
04 Apr 2024

Business Networking in Burnley - BNI Kudos

Prairie Sports Village, Windemere Avenue, Burnley, BB10 2FU

06:45 - 08:30

Business Networking in Lancaster - BNI Castle
EVENT LISTING BNI Castle.png.png
LBV Hub Networking
04 Apr 2024

Business Networking in Lancaster - BNI Castle

Vale of Lune RUFC, Powder House Lane, Lancaster, LA1 2TT

06:45 - 08:30

Business Networking in Preston - BNI Brunch
EVENT LISTING SIZING Brunch .png.png
LBV Hub Networking
05 Apr 2024

Business Networking in Preston - BNI Brunch

Samlesbury Preston Hotel, Preston New Road, Preston, PR5 0UL

09:30 - 11:00

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 Lbv115 Online Graphic
Subscribe now

Weekly news bulletin