Access forms quicker than web forms?

[Advo]

Basically, at the moment at work we have a Access Database, about 20mb.

This contains about:

28 tables linked from Microsoft SQL, but theres loads more that are still used
360 Queries, some arent used much
155 Forms, only a few are used all the time
105 Macros
5 Modules

Now, theres about 12 members of staff using this same form each time.
Im debating at the moment if it would be A) Better in the long run, and
B) quicker to take all these forms and create an online version running
from a webpage.

Anyone got any experience with doing this? i know the code to put it
online, but i just cant work out if it will be benificial to us. Any
ideas?

Thanks

 

[Larry Linson]

If all your users have access to the LAN where the SQL Server resides, then
the Access database application can support a much richer user interface,
and, of course, you will save yourself a good deal of time and effort
because you won't have to reimplement using .asp or ASP.NET or other
software. There's not likely to be any performance advantage to recreating
the applicaion on your intranet, either, and could be slower -- all very
dependent on the design and implementation of the application.

Larry Linson
Microsoft Access MVP