Access or SQL Server

[Guest]

Hi,

I am writing a Visual Studio.NET client server app that will reside on one
PC, the GUI, Business Logic and Database. I am trying to decide which
database to use, either SQL Server or Access. The database on this PC will be
also be accessed by remote PC's to generate reports.

I'm not sure the exact Pros and Cons of both databases.

I'd appreciate suggesstions as to the pros and cons of each database to help
decide which database to use.

Thanks In Advance,
Macca

 

[Rick Brandt]

Hi,

I am writing a Visual Studio.NET client server app that will reside on one
PC, the GUI, Business Logic and Database. I am trying to decide which
database to use, either SQL Server or Access. The database on this PC will be
also be accessed by remote PC's to generate reports.

I'm not sure the exact Pros and Cons of both databases.

I'd appreciate suggesstions as to the pros and cons of each database to help
decide which database to use.

In an environment where you can use Access (Jet) for free and have to pay for
SQL Server then you have to weigh the advantages of SQL Server against the extra
cost.

In an environment where you can choose either without concern for cost then
there is no reason not to use SQL Server over Jet.