Moving Access Online

If you have team members or employees in different locations, you can move your Access database online so that everyone is still working with the same data.

Access Database in the cloud

With your Access database moved to the cloud your team members can access live, current data from anywhere with an internet connection. Although online systems are not as fast as office (or local) systems, with current broadband speeds and the right design the drop in performance should not be a major concern.

There are several ways to go depending on your specific circumstances. Contact us to chat through your options.

Choosing which Online option works best for You

 
 
Sharepoint
SQL Azure
Access App
User Interface
Local copy of MS Access
Local copy of MS Access
Web browser
Data Location
Sharepoint Lists
SQL database
SQL database
Can handle Offline usage
Yes
No
No
True relational database
No
Yes
Yes
Can store attachments
Yes
No
No
Best suited to
 
 
Low volume of transactions with attachments requiring offline capabilities
High volume of transactions requiring speed
Simple systems with large number of dispersed users
VBA code available
Yes
Yes
No
Example
 
 
 
 
 
Organisation with multiple sites or remote workers requiring document storage, e.g. Engineers, Architects, Surveyors etc..
Organisation with high number of transactions requiring robust system that is accessible from several online locations, e.g. Event Organisers/Supporters, Car Parts/Repairs, Accountants etc..
Organisation with dispersed team needing to capture simple information on a regular basis, e.g. Employment Agency, Facilities Management, Sales/Marketing teams, etc..

As you can see, there are quite a few things to take into consideration when deciding which route to go. Moving your Access database to the cloud will give you extra capabilities.

Team members can access the data from anywhere with an internet connection. Your employees can still update data and pull reports when working from home or from a client’s office. With the right blend of set up and system design there is not much of a performance drop with modern broadband speeds.

Contact us now to talk over your options for moving Access online.