Vinney this is one of the reasons why MS developed ADO.NET: it does not require a constant connection to the database. The application connects to the database, gets the data it wants and disconnects. The data is manipulated, the connection to the database is opened, and the database is updated. All kinds of data concurrency rules can be implemented.

By the way this, is exactly how your online banking and services work. You do not maintain a permanent connection to the database.

Additionally, the Jet engine is not a client server database engine. When you develop SQL client-server applications there is a tremendous amount of inherent power in the database engine itself, that will take a lot of load from presentation layer.

If the application is architected as an n-tier(data tier, business logic, presentation layer) it will make for more efficient development paths.

Lytec and the other Medical software are still using Visual Basic 6. This technology is EIGHT YEARS OLD, and was developed before applications had to work in a disconnected environment.

George K. Fahnbulleh
Solutions Architech
Lake Piso Software

Last edited by gkfahnbulleh; 05/12/2008 10:42 AM.