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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SharePoint

From novice to tech pro — start learning today.