Access World Forums

Access World Forums (
-   Access Web (
-   -   Remote Access to Database (

HeatherO 05-11-2018 10:10 AM

Remote Access to Database
Good Afternoon,

I have built an Access database that I need our inspectors and maintenance technicians to be able to connect to (via an IPAD) from the apartments they are inspecting or performing maintenance in. Our office staff uses the database sa well. Right now, the BE sits on our server and each of our office personnel has a FE saved to their desktops. Ideally, we would like a "real-time" connection that updates the data as soon as it's changed in the field. I've started to research this and think that maybe remoting in to our server would be the way to go. Looking for feedback from those of you who have first-hand knowledge. What would be the best way to accomplish this? All advice welcome! :confused:


June7 05-11-2018 11:48 AM

Re: Remote Access to Database
This is not simple. I think options are VPN or web-based db, maybe using SharePoint.

HeatherO 05-11-2018 05:36 PM

Re: Remote Access to Database
Today we were able to successfully connect to the BE using VPN. What would be the advantages of using SharePoint instead? Isn't this being phased out? Also, we are concerned about the number of users that can successfully remote into the BE at one time. Any thoughts?

June7 05-11-2018 05:43 PM

Re: Remote Access to Database
Yes, I have heard SharePoint is going away. Never used it. I would expect accessing db via VPN by multiple users would be no different than accessing locally on network from the db point of view. Users may experience slow data exchange. Depends on bandwidth I suppose. I work at home and all access to office is VPN to servers thousands of miles away. However, not using Access for database. And linkup is over cable, not wireless. Wireless would be a performance issue.

Beetle 05-11-2018 06:09 PM

Re: Remote Access to Database
If you're talking about a situation where each remote user actually has a workstation at the home base on the LAN, and they are using VPN to connect to their local machine and run the application from there, that may be doable. However..


Today we were able to successfully connect to the BE using VPN
it sounds like you are trying to run the front end on the remote device and connect to a Access (Jet/Ace) back end via VPN. This is a recipe for disaster. You will almost certainly end up with corruption in this scenario. Access is simply not designed to operate over WAN or internet. MSoft made a poorly implemented attempt at Access web apps in recent years, but that was more or less a failure and has been scrapped. Terminal services (i.e. Citrix, etc.) is an option, but again, that is where the remote user logs into a profile on the server and the app is run from there.

You could also try using a different database (SQL Server, MySQL and the like) and use an Access front end with unbound forms, etc. but then you are losing all the advantages of using Access to begin with (rad, bound forms...)

HeatherO 05-11-2018 07:07 PM

Re: Remote Access to Database
The users would remote in to a virtual desktop that is housed on the same server as our BE. The FE is saved in that desktop.

HeatherO 11-14-2018 06:09 AM

Re: Remote Access to Database
Just a little update here - we have done this successfully and it worked beautifully!!

We are now looking to make the database accessible over the internet so that our potential tenants can not only apply online, but also update their application data themselves, etc... possibly eventually have our maintenance technicians connect to it to receive and update their work orders. We would want real time data.

I've done some research and am just not understanding the whole sharepoint mess... it looks like Microsoft is no longer going to support this? Unless it's "on-premises"? How exactly does this work and are there other options?

All times are GMT -8. The time now is 04:37 AM.

Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World