SQL or Access DB

Hi all

I am planning on writing a stock and accounts program for the family
business, I understand this is likely to take close to 2 years to
accomplish. The stock is likely to run into over a thousand items and
the accounting side will be used for hopefully many years so the
entries are likely to be vast.

The delema is what is best to use ase the DB engine, Access I have as
part of Office 2002 or should I really be looking at SQL server??

What are the pros and cons between the two??

The DB will only be accessed by one client at this time but never more
than 2.

If the choice is SQL Server is there a version available just for
single clients. I remember using MSDE when I did my ASP.Net book can
this be used to create the initial DB???

Thanks for taking the time to read this, any advice would be very
helpfull to me at this planning stage.

--
DaveG - Learning VB.Net slowly.
Skøyen - Oslo - Norway
.

Relevant Pages

  • Re: SQL or Access DB
    ... Sql Server is soooo much better than access in just about every conceivable ... > I am planning on writing a stock and accounts program for the family ... > single clients. ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Any experience with "The Last One"?
    ... >> will not live long enough to complete the programming part of the ... >> packaging planning, ad planning, lawsuit prevention planning, ... DEC did it by having their workers own stock. ... <snip quitting, finding he can't pull wool over anybody's eyes> ...
    (comp.programming)
  • Re: Ireland - new cross-border stock?
    ... plans to supplement/replace the existing Enterprise services or is ... this a case of planning ahead without a definite role at ... NIR DEMUs turn up in the republic every now and then on specials and the like, and IE stock goes north. ...
    (uk.railway)
  • Re: Ruby Changes in Leopard
    ... just planning on using macports cause it works so well. ... The question I haven't seen asked is how would I switch ... stock versions? ...
    (comp.lang.ruby)
  • New stuff added in our online store
    ... We have added more stock to the online store and are planning to do the ... Glenn Ashley ...
    (rec.models.scale)
Loading