I have a small database that is split and used by 25 users. The users are in 5 different cities, in two states. Currently the BE is on a server and each user has a copy of the FE on there own PC.
I've been looking into converting the Access DB to a web application.
My reason for possibly converting is greater accessibility for the users are they travel and hoping for some increase in speed of the database.
Converting the tables to SQL Server does not seem to be too difficult but, converting the FE to a web application appears to be a huge undertaking.
Am I correct that you would have to recreate all queries, forms and reports and rewrite all VBA code?
If so, is it common to do this or do most stick with an Access database?
Would it be worth just converting the tables to SQL Server and leaving the FE on each users PC?
Again the goal would be to increase the speed of the database and increase the accessibility.
Thoughts? Pro & Cons?
I've been looking into converting the Access DB to a web application.
My reason for possibly converting is greater accessibility for the users are they travel and hoping for some increase in speed of the database.
Converting the tables to SQL Server does not seem to be too difficult but, converting the FE to a web application appears to be a huge undertaking.
Am I correct that you would have to recreate all queries, forms and reports and rewrite all VBA code?
If so, is it common to do this or do most stick with an Access database?
Would it be worth just converting the tables to SQL Server and leaving the FE on each users PC?
Again the goal would be to increase the speed of the database and increase the accessibility.
Thoughts? Pro & Cons?