Shawn
asked on
access hosted front and back ends
Right now I have a few servers but am thinking of decommissioning them soon and going to the cloud.
My setup is as follows:
back end - both MSAccess and SQL Server depending on DB risiding on Windows 2003 Server
font end - MS Access
What sort of hosted solutions are there for both front and back end ?
Budget is relatively low so open source or low cost would be best here.
My setup is as follows:
back end - both MSAccess and SQL Server depending on DB risiding on Windows 2003 Server
font end - MS Access
What sort of hosted solutions are there for both front and back end ?
Budget is relatively low so open source or low cost would be best here.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
The new Office365 plans seem to be fairly low-cost, but it's an ongoing monthly expense, and there would likely be some upfront cost associated with purchase of desktop Office products.
What exactly are you trying to do? Do you host applications on your machines, and others use those apps? More information would help to provide better suggestions.
What exactly are you trying to do? Do you host applications on your machines, and others use those apps? More information would help to provide better suggestions.
ASKER
right now I just want to be able to remotely give access to MS Access. email, office, file management would be a bonus but not essential.
monthly payments are what I'm looking at right now. Rackspace is doing a custom quote but I fear it will be out of budget.
monthly payments are what I'm looking at right now. Rackspace is doing a custom quote but I fear it will be out of budget.
ASKER
just got a trial of Office365. It seems you can build an Access database to share on the Web. They give you a local version of Access 2013, then you upload it to your sharepoint area and can access it online there.
$15/month per user if it works.
$15/month per user if it works.
ASKER
looks like an Access web app would need to be done from scratch rather than sort type of conversion. Not really an option to redo the DBs from scratch.
<<looks like an Access web app would need to be done from scratch rather than sort type of conversion. Not really an option to redo the DBs from scratch. >>
That is correct and web apps at this point have limited capability. No VBA and no reporting capability.
Jim.
That is correct and web apps at this point have limited capability. No VBA and no reporting capability.
Jim.
ASKER
ok, web apps are out.
back to previous idea...or what about Citrix? I've never used it and am not sure what a setup would look like.
back to previous idea...or what about Citrix? I've never used it and am not sure what a setup would look like.
If monthly fees are okay with you, you might consider www.eqldata.com. They can host your database as-is, and you can add users (for additional monthly fees) as needed.
@Scott,
I'm not sure their into hosting per say; they host the web side, but I believe it's up to you to keep the "main" database on a server somewhere else.
May be wrong on that though, but that's always what I've understood the setup to be with them.
Jim.
I'm not sure their into hosting per say; they host the web side, but I believe it's up to you to keep the "main" database on a server somewhere else.
May be wrong on that though, but that's always what I've understood the setup to be with them.
Jim.
Ahhh ... I wasn't aware of that. I assumed they "hosted" the database for you, and you had full rights to makes changes and such.
I asked them for an extended trial for the MVPs, and didn't get much traction from them. I lost interest after that
I asked them for an extended trial for the MVPs, and didn't get much traction from them. I lost interest after that
ASKER
so I looked into Citrix hosting and it seems a little prohibitive for my purposes.$50/user/month at the low end.
Hosted Terminal Server looks like it might be the solution. Just need to find one that is reasonable now. Rackspace is getting back to me.
Any other TS hosts anyone knows of?
on the aside I can't believe how limited/archaic Access web apps is...seems like they took a 10 year step back.
Hosted Terminal Server looks like it might be the solution. Just need to find one that is reasonable now. Rackspace is getting back to me.
Any other TS hosts anyone knows of?
on the aside I can't believe how limited/archaic Access web apps is...seems like they took a 10 year step back.
<<Any other TS hosts anyone knows of?>>
It's not a cheap proposistion. Either you rent a server and do all the work; installing, admin tasks, but the software, etc
or
You have someone do all that for you.
You will find that for this, the cheapest route is to maintain your own hardware and do everything in-house. Of course that depends largely on what you feel your time is worth.
Jim.
It's not a cheap proposistion. Either you rent a server and do all the work; installing, admin tasks, but the software, etc
or
You have someone do all that for you.
You will find that for this, the cheapest route is to maintain your own hardware and do everything in-house. Of course that depends largely on what you feel your time is worth.
Jim.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thx everyone for the insights
And on that point, there is no "open source" for hosting your Access DB. Someone will need to run a server, and their not going to do it for free.
Jim.