Re: Opening an Access database in Delphi



"Jeremy Collins" <jd.collins@xxxxxxxxxxxxxxxx> wrote in message
news:op.st87enll4al0tm@xxxxxxxxx
> 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.


Thanks for the responses everyone. I'll probably go with a different
solution, like DBISAM.

- Dave


.



Relevant Pages

  • Re: Application deployment with Jet Database 4.0
    ... Basically you would install Jet in the same way as MDAC: ... exe that will launch the Jet setup before launching your msi. ...
    (microsoft.public.dotnet.framework.setup)
  • Re: Application deployment with Jet Database 4.0
    ... Jet is no longer included with MDAC. ... InstallSite - Resources for Setup Developers ... > How can I tell setup to install Jet Database 4.0 if it is needed? ...
    (microsoft.public.dotnet.framework.setup)
  • Re: Jet Dabatase Engine
    ... > We managed to get the ODBC driver working when we realised that a couple ... > DLLs were missing ... >> There isn't a standalone installer for Jet (it was dropped from MDAC as ...
    (microsoft.public.windowsxp.embedded)
  • Re: No SQL OLE DB connectivity
    ... Renaming the dlls (they're in System32, ... but Windows file protection will keep overwriting...you can install MDAC 2.8 ... >>> been able to get MS Access to connect with the MS SQL Server at all. ... > I've tried multiple times to reload MDAC 2.8 to no avail. ...
    (microsoft.public.data.oledb)
  • Re: Use VS 2005 Setup project for VB 6 application
    ... There are a number of reasons why Dlls are not included in the setup, ... folder is part of the OS and you do not redistribute them, ... A VS 2005 setup project builds a standard MSI setup like most other tools ... I have a few of simple questions regarding VS 2005's setup Project. ...
    (microsoft.public.dotnet.framework.setup)