Question How to remotely share a complex Access db

MS1234

Registered User.
Local time
Today, 05:16
Joined
Nov 28, 2016
Messages
17
Hi, I have a large highly complex MS Access database that was previously accessed*by multiple users via*a networked company citrix server (front end)*and SQL server (back end). What are my options for taking this database and making it available to multiple users around the world who do not work in a networked environment. Web Database option is no good as I have a mass of VBA coding, complex queries (within Access and SQL), complex forms and reporting etc.

Thanks
 
If they have NO network access then I can't see how you can do it.
If they have, then the remote desktop / citrix route is by far and away the best solution. Access does not do WAN very well, if at all in most circumstances.
 
They have internet access, I meant they are not part of a company network (no servers). Without any servers the only citrix option is citrix in the cloud which is very expensive. I need a low cost solution of enabling people to access it remotely. Thanks
 
Terminal server or whatever it is currently called at the moment is probably the cheapest option, but still not that cheap. I'm not sure if there are any open source equivalents?
 
Given the challenges that would occur for any other action, the only viable method is to somehow allow them to access the server that hosts the database or the (Citrix-like) server that hosts the application. Without SOME kind of networking solution, you are hosed to tears.

Note that I have no stock in the company that I am about to suggest so this is not self-serving advertising. In the past, I had some reasonable results using Attachmate Reflection, which includes a way to do X-terminal services back to your machine that would be the host. You might wish to talk to them about how to manage this problem. But still, if you don't have a server-class machine, your "host" would be swamped in a heartbeat once users start hitting it.
 

Users who are viewing this thread

Back
Top Bottom