T
Terry Roberts
A stand-alone application I developed for Access 2000 is
now being used in several offices in my company.
Management would like to be able to access the application
remotely (management in Atlanta, MDB files in five
different cities). Although the company has a WAN,
attempting to access each database remotely is IMPOSSIBLY
slow. I've split the database (using Access 2K database
splitter), and reduced controls/lookups/queries as much as
possible.
I'm convinced that the application needs to be redesigned
as a true client-server app, using SQL in Access 2002. My
question is, would it be better to develop it as a web-
based application, or can I do an Access executable which
will tie back to the SQL server across the WAN? I would
prefer to do it as an Access application so I can employ
more controls & features, but am concerned about the speed
issue.
Recommendations requested. If anyone has a SQL client-
server design similar to the one I've described that I
could view in action to see performance for myself, that
would be great.
TIA,
Terry Roberts
now being used in several offices in my company.
Management would like to be able to access the application
remotely (management in Atlanta, MDB files in five
different cities). Although the company has a WAN,
attempting to access each database remotely is IMPOSSIBLY
slow. I've split the database (using Access 2K database
splitter), and reduced controls/lookups/queries as much as
possible.
I'm convinced that the application needs to be redesigned
as a true client-server app, using SQL in Access 2002. My
question is, would it be better to develop it as a web-
based application, or can I do an Access executable which
will tie back to the SQL server across the WAN? I would
prefer to do it as an Access application so I can employ
more controls & features, but am concerned about the speed
issue.
Recommendations requested. If anyone has a SQL client-
server design similar to the one I've described that I
could view in action to see performance for myself, that
would be great.
TIA,
Terry Roberts