linking backend

Hi EE
Not sure if this the right spot for this question but I will make a start here.
I have designed a small app (Typical Back and Front end Access 2013) for my local club, member’s information etc. They want three people to have access to it, each working from home with a laptop. I am currently working through sql server 2014 express. I have also looked at Web apps and SharePoint. What I am looking for is some advice for the best way to approach it.
Any help appreciated

chestera
chesteraAsked:
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.

John TsioumprisSoftware & Systems EngineerCommented:
Given the fact that already your Backend is SQL  if the information is somewhat small in size (a few Mb) then you can sign up in a free Cloud SQL service (there a few) and upload the data to this..thus making them available from anywhere in the world....this is the free worry free solution..
If your data exceed the limits there are 2 options :
1. rent a VPS ...either Linux (you must change your BE to MySQL/PostGre...) or windows (more expensive)
2. setup a server somewhere ...i reckon that the data are relatively small in size ...so any decent machine would do ...install Windows/SQL and make it accessible over the Internet
PatHartmanCommented:
Access is not optimized to work over the internet.  You can do it if your app is designed to work with disconnected recordsets and you have a fast connection but most home users will be very disappointed in performance.

RDP or Citrix are better options.  You can host these on your own servers or use a third party.  With Citrix the app runs on the Citrix server.  The data should also be on the Citrix Server or at least on the same LAN for best performance.  Then the remote users connect via a web browser.  The Access app does not have to change at all.  It is configured exactly the way it would be if you were running it on your local LAN.  Citrix should provide performance equal to or better than a LAN.  RDP is similar.

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
John TsioumprisSoftware & Systems EngineerCommented:
Well connecting Access to an online database solution is not that straightforward but is viable
On this link you can check a small demo i have prepared for a client of mine
Take note :
1000 rows - 90 columns (not my design)
ADSL line around 14 mbps
Ping 50 ms
VPS hosting ...MySql ServerIntel(R) Xeon(R) CPU L5640 @ 2.27GHz, 1 cores, 1 GB memory
So i reckon that with careful design you can get this working
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Dale FyeOwner, Developing Solutions LLCCommented:
John,

Note that Pat said "not optimized to work" , she did not say "does not work".

I know an MVP who works with a dedicated fiber optic cable and has no problem with users running Access against a BE that is located 150 miles away.  That is by far the exception, very few people have access to those speeds.  I have a 150Mb connection speed available via Verizon FIOS and when I connect remotely to a database running on a client site, I see a significant performance degradation compared to when I log into that server via Remote Desktop.

It can be done, but don't be surprised if users have time to get a cup of coffee when they open a form, or run a report.

Dale
John TsioumprisSoftware & Systems EngineerCommented:
Well you are right Dale that its far easier to work by RDP but its all about data & design...i just said is viable and if you design it carefully your users won't have time for cup of coffee ....maybe a small zip...:)
And for this specific case the needs seems to be very little..
PatHartmanCommented:
I wouldn't call it viable.  I would call it possible with a lot of work and a very good internet connection.  That's a big difference from "viable".  I have tried this several times because my clients would LOVE to use the technique but I haven't found a provider would could provide sufficient bandwidth and speed to make the solution viable unless I completely rewrote the app.
John TsioumprisSoftware & Systems EngineerCommented:
Well a lot of work is needed but if you watched my video is more than possible....
I would also recommend Rdp or even better RemoteApp that gives that local feeling  ...but the OP mentioned that the BE is on SQL that's why i recommended the online solution
PatHartmanCommented:
The problem is that you can't take an access FE working with an SQL BE and just move the BE to the cloud.  It doesn't work.  You have to pretty much rewrite the FE.  Access works very well over a LAN not so much over a WAN.
John TsioumprisSoftware & Systems EngineerCommented:
Of course is a bad idea to just place the BE to the cloud just by copying it and making the relinks...it would be a performance killer ...to put it simply most of the tables would be gone and almost all the communication FE<->BEwould be made from either passthrough queries or VBA code...no argue on that...just be the OP mentioned that its a small app and probably with few tables he could make that extra step to make its app cloud based...
chesteraAuthor Commented:
Hi EE

Thank you all for that info. How do I close the question and select best answer. It's been awhile since I used EE and things have changed

Alan
PatHartmanCommented:
If one answer solved the problem.  Click Best and don't choose any others.  If you think it took multiple answers, then click best for the first one and assisted as many times as you want.  The points will be divided equally but you can override that.
chesteraAuthor Commented:
PatHartman

Yep I understand select Best etc. My problem I can't see a best button, all I can see is Experts comments and "was this helpful"
I want to select the first comment for best and a couple as assisted

Alan
chesteraAuthor Commented:
John Tsioumpris

Hi John
My back end isn't SQL I was trying to work my way through SQL Server Express 2014 but haven't got there yet. I was looking for if it exists a simpler way

Alan
John TsioumprisSoftware & Systems EngineerCommented:
Given the original info of you working with SQL i assumed the BE is in SQL...if this is not the case the easiest way would be Pat's recommendation of RDP...if you go a little further a RemoteApp it would a seamless experience for end user.
chesteraAuthor Commented:
John Tsioumpris

Thank you John for you help.
Last time I used EE there were to options Best answer and assisted answer. I am tyring to awards points and close but can't find these options

Alan
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
Query Syntax

From novice to tech pro — start learning today.