Share Ms Access Tables

Hi everyone,
  I have one question about share ms access tables, which platform is best to share my tables into the cloud? Also, after share my tables I want to use anywhere also by using any pc which I mean using the same database with various pc! if you know the best platform please give me information also about cost if cheaper that will be better.
Regard,
adamdaban dabanStudentAsked:
Who is Participating?
 
John TsioumprisSoftware & Systems EngineerCommented:
If you want Access tables then you choose the recommendation from Scott...RDS and everything related..Windows VPS
If you want the cheapest cloud solution then its Linux/MySQL for cheap VPS..
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
The only viable way to do this with an Access database is using an RDS system, which essentially allows you to log into a virtual desktop and run your Access application that way.

You can't put your Access tables on a cloud and share them. Access databases must be on the same physical network as their frontend.

You can try to use Sharepoint to host your tables, but Sharepoint is not really intended to do this. It's a document management system, and was not really intended to do this.

Or, you could use a SQL Server backend and host your database on the Azure platform. This generally means you must build your frotend to take advantage of that structure. If you're a drag-n-drop programmer, in most cases this won't work well.
1
 
John TsioumprisSoftware & Systems EngineerCommented:
If you want to go to the end...you just rent a cheap VPS...they start from 1€+VAT/month and you setup MySQL on Linux...then your tables are available from anywhere in the world....probably less tables ...more pass through queries...just linking tables from a cloud SQL to Access is a performance killer.
1
Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
just linking tables from a cloud SQL to Access is a performance killer.
I've had pretty decent performance using methods like that, but the datasets were fairly small (<30000 records) and I had the skillset (and time) to tweak the application pretty heavily. I certainly wouldn't recommend it as the best way to manage an Access system, but it can work.
1
 
John TsioumprisSoftware & Systems EngineerCommented:
If you take the time and ofcourse the necessary skillset which you certainly have anything is possible...but there is that wrong double click on remote table with a lot of records....you just have to wait for the timeout...:)
1
 
adamdaban dabanStudentAuthor Commented:
John Tsioumpris, thanks for your suggestion could you please give me a resource name?
0
 
John TsioumprisSoftware & Systems EngineerCommented:
I think its advertising and i am not sure if its allowed...just search Google for "Cheap VPS from 1€/month"...it should be in the first results...
0
 
adamdaban dabanStudentAuthor Commented:
Thanks, but these days ago I checked from google mostly tutorial is talking about SharePoint with office365, your advice a bit different also you have an excellent experience, so your best option is better using VPS for share my access tables right?
0
 
John TsioumprisSoftware & Systems EngineerCommented:
Yes,my personal recommendation is use a VPS....i have some data already on my VPS and i plan to upload even some more...and all this accessible from anywhere from the world...i can even query my data from my smartphone using a MySQL client for android
0
 
adamdaban dabanStudentAuthor Commented:
Great, so you suggest changing my backend to SQLServer? or keep MS Access tables and upload to VPS hosting?
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
You'd have to use something other than an Access backend. As mentioned before, you can only connect to an Access backend from the same physical network.

I don't have any real experience with a VPS, but my understanding would be it's very much like a cloud-hosted system (very much like my Azure suggestion, in other words). You will get the best experience from this if you create or modify your application to take full advantage of the client-server architecture. As I mentioned earlier, if your programming style is mostly bound forms and SELECT * queries, you'll likely see some serious performance issues.
1
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.