 | |
Re: VB.net client-server application - acces or sql database?
comp.database.ms-access comp.database.ms-access
 |
| | Thread Tools | Display Modes |
#1
 
| |||
| |||
|
Re: VB.net client-server application - acces or sql database? -
04-02-2004
, 10:49 AM
|
Hello, I just started my internship in a company. They assigned me on a 2 project's that I need to develop using Visual Basis.net as a basis. Both programs have clients running on each pc of the IT department and send the input info to the database that is running on the server. Now the problem is that I wonder what kind of database I would use. I could use the Microsoft Access version 7.0 but I wonder if I could or should? Meaning, I don't know if it's possible to develop a good Access database which is managed by a vb.net program running on the server and an vb.net client program to communicate with it. Would it be better to use sql or maybe another sort of DB? And what's the easiest to develop? Because I only have a pretty limited amount of time to develop it and I've never really made client-server applications with Visual Basic. I hope someone can help me out? Thx in advance for you reply Greetings Philip |
Philip,
The answer really depends on how many transactions the database will
be handling every day. If you expect a relatively light-to-medium load
on the database daily, Access should be good enough. If there will
only be 2 client machines hitting it each day, then the load probably
isn't too heavy for Access.
There are other considerations, however, such as the company policies
on data integrity and where the business rules should reside.
Depending on the company, SQL Server might be the choice, because of
the advantages of SQL Server stored procedures vis-a-vis Access
queries for these two considerations.
Norm
|
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
| |
Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.