I have an application developed in MS access. It consist of forms, report, queries and tables. I now want to deploy this application for use by 2-3 people, and at the same time want to move to MS Sql Free edition.
My idea is as follows ;
1. Split access to two parts, frontend and backend database
2. Convert backend to MS SQL
3. Host MS SQL on my desktop, and let my employees to connect to this database from the front end. This will save cost of one additional server (I already have router in office so I guess this connectivity should not be an issue).
Are there any guidelines on how this should be done ? Is it fairly easy to do this ? Do you see any problems on uasing MS SQL free edition ?