troubleshooting Question

How to move a SQL-Server / Access "project" application off a local server and onto the Cloud?

Avatar of colinasad
colinasadFlag for United Kingdom of Great Britain and Northern Ireland asked on
Microsoft AccessCloud ComputingMicrosoft SQL Server* migrate
12 Comments1 Solution142 ViewsLast Modified:
Over the past couple of decades I have developed an Access "project" (ADP) front-end to a SQL-Server database for a client.
They are still running SQL Server 2008 R2, and the Access front-end is still being developed under Access 2007, after Microsoft dropped support for "projects" in more recent Access versions.
At my client's site, the SQL Server database runs on their own server, and each user has an "ADE" copy of the Access front-end on their own PCs, that connect with the SQL Server database.

My client would now like to move to a web-hosted system, allowing their own staff and customers to access their data from pretty much anywhere.

Do we have to start from scratch? This client has been running their business since the late 1970s, and they now have quite a sophisticated application that has grown from a pre-MSDOS platform, through MS-DOS, and into its current Access / SQL-Server incarnation. It would be good if we could somehow make use of the existing SQL Server database and Access work. I'm pretty sure SQL-Server databases can be hosted on the cloud (I connect to my client's database remotely using its IP Address), but is there a suitable web-based front-end that would be compatible with my Access application?

Can anyone point me in the direction of a migration path that might achieve this? If not, to any case studies of anyone else who has achieved this sort of conversion? I can't be the first person faced with this task!

Any suggestions or help gratefully received.
Thanks. Colin.
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 12 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 12 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros