Converting an MS Access database to SQL or .net
Posted on 2013-05-29
We have two access databases which have been separated into a front end and a back end. The back ends are between 5mb and 15mb and the front ends are 25mb and 37mb. Some of the people in the organisation now want to be able to access the database when they are working from home and as you know with ms access this is a problem.
I now need to move these databases to some other platform but as you can see the databases are very small and they are for a very small business so we do not have a lot of resources to spend on it. We currently have a small business server 2008, the one without an SQL license and total of 7 users.
1. What would be the best route to achieve what we want to do, can SQL Express work in this type of environment?
2. Is there an easy way of doing the migration I have access and vb knowledge nothing much else but am willing to learn what ever needs to be done.
3. Can we only migrate the back end and leave the front end in access?