We have an Access 2010 database that I designed. It does not use anything complex (I am just not that advanced), but it is loaded with code on multiple forms and subforms. What we want to do is to make it available to salespeople who are on the road and users at other locations than the main location.
I would like to use Sagekey to package the front end of the program (the forms and reports) into a downloadable exe. Right now the database is not split and when someone needs access to it we put a shortcut on their desktop. We also want to use Sagekey so that we don't have to load Access 2010 on everyone's machine (and we also think it would be easier if the user downloads the exe and installs it instead of trying to put a shortcut on their desktop).
Here is the biggest problem though. My program (MINE) uses linked tables that are in another program. That other program (I'll call it OTHER) is on the same server as MINE so they talk to each other with no problem.
One of the other IT people set up virtual machines which have Access 365 on them (so the Access 2010 requirement might be moot) and he set up these VMs to be able to get to the server with both MINE and OTHER on it. I installed MINE on the VM so the front end is now on the VM and the back end is still on our server.
I tested MINE on a VM and it ran REALLY SLOW. I assume it is running slow because it has to go thru the internet to get the data on the back end.
I do not know if I am explaining this very well, but we would like to give all the salespeople and users at the other locations access to their own VM which would give them access to MINE.
Can anyone give me advice on how to distribute this program (MINE) so that others can use it and it runs at a good speed (we are also considering using EQL-Data as a way to get it "up on the internet")