Link to ms access back end via internet?

Link to ms access back end via internet?
Hi:
When separate ms access database into two files (interface & back end).
Is it possible to link to the back end file thrugh Internet?
Please help.
Mohammad Alsolaimanapplication programmerAsked:
Who is Participating?
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.

Gustav BrockCIOCommented:
Yes, if you have a reliable and low-latency 100 Mb/s link (= fiber connection), but that's normally not the case.

/gustav
0
Mohammad Alsolaimanapplication programmerAuthor Commented:
Please could I have an example? If I put my back end file to the google drive, dose that will work?
0
Gustav BrockCIOCommented:
No. The server must be a standard file server with SMB file sharing. This will normally mean a corporate server on a corporate WAN, though it could be a hosted server at, say, Amazon AWS. Such servers are, however, normally restricted to allow access from specifically assigned IP adresses for security reasons.

/gustav
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mohammad Alsolaimanapplication programmerAuthor Commented:
I am very sorry! I could not understand. Because of my little knowledge.
What should I do if I want to use my ms access application in several cities?
Any idea please.
0
Gustav BrockCIOCommented:
The recommended method is to convert the backend to SQL Server Express (any version, 2012 is the current, but 2008 is fine). It can run on very modest hardware.

This you can host on premise if you have decent upload speed and a fixed IP address, or you can host it at Amzon, Azure or any other reliable hosting company. Many web hosts offer shared SQL Servers at very low prices, though database size often are restricted, here at 200MB as a start:

https://en.unoeuro.com/products.php

/gustav
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
PatHartmanCommented:
Your best option is Citrix.  That will allow you to keep the application as is.  If you run the Citrix server in house, your Access BE would be hosted on the Citrix server.

You can use third party hosting companies but the per user cost is a bit pricey.

You could convert the BE to Azure.  Then your Access FE could connect to the Azure database via the internet although this could be slow.

If you have the latest version of SharePoint and Office 365 (O2013), you can use that to make a hybrid application.  All the data will be in the Azure BE but if necessary, you could rewrite some parts of the FE so they can be hosted in SharePoint and used across the internet.

The final option is to completely rewrite the FE as a web app in which case there would be no reason to use an "Access" BE and so it should be converted to something more web compatible.

With the exception of option 1 - Citrix, other options will incur significant up front costs and probably require technical skills you don't have.   Notice also that in all cases except #1, the BE is converted to SQL Server or some other RDBMS.
0
Mohammad Alsolaimanapplication programmerAuthor Commented:
thanks to all of you
0
Gustav BrockCIOCommented:
You are welcome!

/gustav
0
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 Access

From novice to tech pro — start learning today.

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.