Re: Database Development - Access or MSDE?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Mitchell Vincent (mitchell.vincent_at_gmail.com)
Date: 10/13/04 

Date: Wed, 13 Oct 2004 13:10:48 -0400

Bonj wrote:

>>The MSDE package is *far* to huge to be of any real use at over 70 megs,
>>so I'm left with Access.
>
>
> Is it? I've got an installer for it called MSDE2000A.exe and it's 43,259KB...

Perhaps I downloaded more than I should have... sql2kdesksp3.exe is what
I got - from a reference in MSDN I believe. It is almost 70 megs in size.

Coming from using PostgreSQL and SQLite even a 40 meg install for an
embedded database is hefty. I don't think I could convince users of my
shareware that a 50 meg install file is OK :-)

Based on the comments here I think I'll give Access a toss. Thanks!

>
>>Access has had a bad rep in the past but I'm wondering if recent
>>versions (like, the last 5 years) have addressed the issues that it had
>>previously. I remember speed and relability with multiple users were its
>>two shortcomings.
>
>
> In my experience, it's very good for any database that is more of the
> megabyte size range than the gigabyte size range. It does get a bad press
> because of this as people tend to believe it is a 'toy' database, when it's
> not - it's just that people try to force too much data through it. When used
> correctly, it is a very professional tool and can handle extremely complex
> things. It's also very nifty because of its single-file based architecture.
>
> 

--
- Mitchell Vincent

Relevant Pages

  • Re: SqlNotificationInfo
    ... You have any good references to point to beyond what's on MSDN? ... trying to fire notifications based upon events occuring in the database and ... the only result I've had is to lock up the database. ... anyone (outside of Microsoft) who actually got the scheme working. ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Dataset with master and multiple nested tables in DotNet 2.0 WinFo
    ... Are you having trouble to put modified data back to DataSet or update data ... back to the database? ... I have some good samples in MSDN that ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Newbie to VSTO
    ... Walkthrough: Binding Cells to Multiple Columns in a Table ... MSDN library. ... I want to populate excel from a database table, ...
    (microsoft.public.vsnet.vstools.office)
  • Re: Maximum Database Size Reached
    ... Deleted Items Retention is set to 0 days, convince users to delete as ... connectors (or they will bring more mail into database). ... Kevan wrote: ... > which explains that i need to defragment the database to ...
    (microsoft.public.exchange.admin)
  • SSO Confiugration and PayStub Sample
    ... I'm trying to get the PayStub sample posted to MSDN ... errors in the event log or in the database. ... "The DataCache database 'Paystubdata' cannot be reached on server ... 'SERVER' with the credentials obtained from SSO. ...
    (microsoft.public.sharepoint.portalserver)