I have an existing application that has grown from a normal 1 concurrent user system to about 8 concurrent users. The initial application was written accessing a MS Access database. I would like to migrate it SQL Server and it seems I have a couple of options; rewriting the application to connect and manipulate the data in SQL Server, or move the data to SQL Server and use MS Access with linked tables. The later seems like it could be implemented much quicker. Any comments to help me select the approach I take are appreciated.
