Link to home
Start Free TrialLog in
Avatar of chestera
chestera

asked on

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
SOLUTION
Avatar of John Tsioumpris
John Tsioumpris
Flag of Greece image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
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
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
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..
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.
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
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.
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...
Avatar of chestera
chestera

ASKER

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