Re: Opening an Access database in Delphi

On Wed, 20 Jul 2005 15:53:38 +0100, Dave <im@xxxxxxxxxxx> wrote:

Hi all,

The subject is a tad vague/misleading. My question is, are there any
DLLs or other files that need to be installed with my Delphi 6 app
in order to open and work with a Microsoft Access 2000 database, or
are all the necessary files included with Windows?

I'm thinking of switching a freeware program I've written from using
a flat file for data storage to Access, but I want to avoid having
to figure out which DLLs, etc. that I'd need to include with it.


The target system needs ADO installed (or MDAC, depending on what you
want to call it). All Windows systems since Win2K have this already, but
you can download the client-side setup from

  http://msdn.microsoft.com/data/mdac/downloads/default.aspx

If your application uses Access tables, then the client machine also
needs the Jet (Access database) engine files, which are no longer
included with the MDAC setup. The Jet redistributable can be found on
the same page.

DO NOT create a setup for your application that also automatically
installs this stuff. Provide an FAQ or handle the error and give
the user a link to download MDAC and Jet for themselves.

--
jc
.

Relevant Pages

  • Re: 10G tns questions
    ... patch and created a blank database to import the contents ... dislike for grid control as it will see the new database when I discover ... SQL locally when I set the ORACLE_SID and bypass the listener. ... Some kind of weirdness happened with one of the installs I think. ...
    (comp.databases.oracle.server)
  • Re: Unable to print form access, just a hint of other config issues pe
    ... with default installs from a network install point. ... Further investigation revealed that when creating a database ... *Problem is repeatable amongst some users and not others ... *Anwhere the print problem exists on the test database, ...
    (microsoft.public.access.setupconfig)
  • Re: Offline Defrag error on Exch 2003 Ent server
    ... ESEUTIL is to create a new mailbox database, move all the mailboxes from the ... the priv and pub files in the mdbdata folder. ...
    (microsoft.public.exchange.misc)
  • Re: Offline Defrag error on Exch 2003 Ent server
    ... However, since you're running Enterprise, a better option than running ESEUTIL is to create a new mailbox database, move all the mailboxes from the database you're trying to defragment to a new one, dismount the old database, delete the file, and then mount it again to get a bright, shiny, new tiny database. ... the priv and pub files in the mdbdata folder. ... Like I said, I first tried running eseutil from the e: bin location, but ...
    (microsoft.public.exchange.misc)
  • Re: Exiftool
    ... The big question is, which database, how much effort is it going to ... .INI file using XWP Helpers code instead of PM ... restoring my January archive about twice per week. ... use it for a few installs. ...
    (comp.os.os2.apps)