| When you need a database
solution on a Microsoft network that will scale better than Access (20+
users editing at the same time, and 2+ Gigs of data) then a client/ server model is
called for.
Using SQL Server for the data storage and Access or VB.NET (or
classic VB for that matter) we can build highly robust systems.
If you are surprised by the idea of Access as a client to SQL
Server , you shouldn't be; Microsoft endorses this, and has built Access
Projects to enable it. If you have an existing Access program we can move it
into SQL Server and keep much of the front end code and business logic in
Access. thus maintaining your investment.
Other ways to go: We can also us MYSQL as a server (on one of your computers) in
place of the more expensive MS product. Indeed , if you are thinking of
taking your data onto the web at some point, we can build a local database
application in PHP and MYSQL and later host it on a web server.
There are a wide and healthy range of choices now, choosing one of
them is best driven by what you want done and where it will run ~ call us
for more information
|
