Advice about migrating Access to SQL
Posted on 2013-05-14
One of my clients has an Access 2003 database running within a Citrix environment, which will be phased out in about a year. However, one of their other offices wants to use this database for the rest of the year, and there could be up to 40/50 users, concurrently using the database (and potentially accessing the same records).
My initial suggestion was to keep the 2003 front-end and migrate the back end to a SQL2008 back-end. I know that I need to update the front-end to take advantage of SQL - but just wanted to see what your thoughts were.
If this is to happen, they would probably need to upgrade the Citrix server and I was going to provide a 2003 runtime licence (using the SageKey environment). However, as it's a pretty basic application, I was also considering moving the front-end to a C# based app. Again any thoughts would be greatly appreciated. It is after all an in-trim solution.