Home All Groups Group Topic Archive Search About
Author
15 Dec 2005 4:56 PM
Macca
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/ Express or use Access with JET engine.
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

Author
15 Dec 2005 5:02 PM
Jens
Author
16 Dec 2005 11:02 AM
Macca
Thanks,
Macca

Show quote
"Jens" wrote:

> Hi,
>
> http://www.microsoft.com/sql/solutions/ssm/access/compare-access.mspx
>
> HTH, Jens Suessmeyer,
>
>
Author
15 Dec 2005 5:08 PM
David Portas
Macca wrote:

Show quote
> 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/ Express or use Access with JET engine.
> 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

Please do not multi-post!

I replied in microsoft.public.sqlserver.server

--
David Portas
SQL Server MVP
--
Author
15 Dec 2005 5:16 PM
Aaron Bertrand [SQL Server MVP]
> 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/ Express or use Access with JET engine.

Access has several limitations that I document here:
http://www.aspfaq.com/2195
Author
16 Dec 2005 11:03 AM
Macca
Thanks,

I want to use SQL Server. This will help,

Macca

Show quote
"Aaron Bertrand [SQL Server MVP]" wrote:

> > 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/ Express or use Access with JET engine.
>
> Access has several limitations that I document here:
> http://www.aspfaq.com/2195
>
>
>

AddThis Social Bookmark Button