MS Access replacement?

From: Dave A. Law (dlaw_at_barton-canada.com)
Date: 03/31/04 

Date: Wed, 31 Mar 2004 09:51:10 -0700

I'm looking to replace MS Access for an application I'm selling due to ADO
problems I'm having with some users and wanting to get rid of the having to
include ADO (large file) within my install. I want to be to ensure that my
application will run properly the first time, rather than running into
problems, which I know is costing me sales.

The application requires a simple single-user database with only 4 tables.
The main table could grow to have hundreds of records, whereas the other
tables are probably less than a hundred.

What I'm looking for is something that doesn't rely on ADO (or any other
Microsoft technology) or BDE but rather has a small footprint with either
database control embedded within the application or with few smaller DLL's
required.

Ideally, I would like a single database file. It would have to have the
standard functionality I can find with Access such as blob support, though
isn't so complex that it is going to take me a few months to figure out how
to use. It would also be nice if there was an easy migration path from
Access to it.

- Dave A. Law

Relevant Pages

  • Re: Using ODP.NET connection for executing ADODB Command object
    ... the old ADO and move on. ... Can I use the same currently open connection ... > You really should byte the bullet and get rid of old ADO. ... > ODP.NET binds parameters by position, or by name, whichever you prefer, ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Remove apostrophe from text (export to Excel)
    ... Why exactly do you need to get rid of it? ... For Excel it defines the cell as ... when using ADO to read that data it should not ...
    (microsoft.public.data.ado)
  • Re: Ado Error
    ... COM based ADO is still used in many of my COM based DLLs. ... Over time, I will replace, but its not something I can snap my fingers and be rid of today:) ... Did you add reference to the ADO from your application? ...
    (microsoft.public.vb.database.ado)
  • Re: MS Access replacement?
    ... "Dave A. Law" wrote in message ... > I'm looking to replace MS Access for an application I'm selling due to ADO ...
    (borland.public.delphi.thirdpartytools.general)
  • Re: MS Access replacement?
    ... but you won't care after you've tried it: ... > I'm looking to replace MS Access for an application I'm selling due to ADO ... > The application requires a simple single-user database with only 4 tables. ...
    (borland.public.delphi.thirdpartytools.general)