Re: SQL or Access DB

If the database design is normalized, then it's less likely that size will
become an issue. A non-normalized database will grow exponentially.

JET ("Access") could be used, as I have in the past for a small system with
less than 10 users, but in time, you will sooner or later hit a locking
issue and/or possible corruption.

As noted by Cor, MSDE is a real bitch to deploy (the cynic in me says that
was by design), so the best "free" choice for a networked solution would be
SQL Express 2005. I'm not sure about the licensing issues in your scenario.

Otherwise, for a small business, if you don't already have a server
installed and plan to build a small network, you might consider buying Small
Business Server Premium. It comes with SQL Server 2000 Standard.

"DaveG" <newsgroup@xxxxxxxxxxxxxxx> wrote in message
news:O9mdnbY3z-GFdWHfRVnzvA@xxxxxxxxxxxxxx
> 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: WAP, ASP engineer required - London
    ... > at the company I work for we need to hire in London a WAP ASP engineer ... > You should have experience of SQL Server database design and as ... online service development the ideal ... > candidate will be technically minded and have experience in SQL Server ...
    (microsoft.public.inetserver.asp.general)
  • Re: Record Update Locking
    ... this by checking a timestamp column, or all of the columns in the table, to ... Pro SQL Server 2000 Database Design - ... How can I make the update record available into one user at ...
    (microsoft.public.sqlserver.programming)
  • Re: A peculiar problem
    ... Pro SQL Server 2000 Database Design ... >>> I need to alter data types in all my stored procedures and triggers ... >> Compass Technology Management ... >> Pro SQL Server 2000 Database Design ...
    (microsoft.public.sqlserver.programming)
  • Re: Varchar vs. Text
    ... Pro SQL Server 2000 Database Design - ... All other replies may be ignored:) ... > I want to go with varchar because I would like to put a clustered index on ... >> Pro SQL Server 2000 Database Design - ...
    (microsoft.public.sqlserver.programming)
  • Re: Varchar vs. Text
    ... just an arbitrary amount, or do you have requirements to go this long? ... tableKey ... Pro SQL Server 2000 Database Design - ...
    (microsoft.public.sqlserver.programming)