The "Microsoft.Jet.OLEDB.4.0;..." driver is in fact the correct driver to
use with Access 2000 (not sure about Access 97). ADO uses the Jet OLEDB
driver underneath to talk to Access. You would have to check the MDAC docs
to see the exact list of other drivers (I think it includes FoxPro, PDox 4,
Excel, DBase, etc...).
Xander
----- Original Message -----
From: "Alan Rose" <[EMAIL PROTECTED]>
To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
Sent: Thursday, August 31, 2000 2:43 PM
Subject: RE: [DUG]: MS Access
> Thanks. What I'm still not sure on is the provider to use in the
connection
> string.
> e.g I currently have
> Provider=Microsoft.Jet.OLEDB.4.0;Data
> Source=C:\mydb.mdb;Mode=ReadWrite|Share Deny None;Persist Security
> Info=False
>
> What drives can I rely on to use with MDAC. I only chose
> Microsoft.Jet.OLEDB.4.0 cause it was in my list when i built the
connection
> string.
>
> -----Original Message-----
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On
> Behalf Of Xander van der Merwe
> Sent: Thursday, August 31, 2000 2:21 PM
> To: Multiple recipients of list delphi
> Subject: Re: [DUG]: MS Access
>
>
> The client only needs to install the latest Microsoft Data Access
Components
> (MDAC) which is actually installed with IE 5.x anyway. Otherwise you can
> just download the +- 7MB installation from www.microsoft.com/data - the
file
> is called mdac_typ.exe of which a version actually comes on the D5 cd.
>
> Xander
>
> ----- Original Message -----
> From: "Alan Rose" <[EMAIL PROTECTED]>
> To: "Multiple recipients of list delphi" <[EMAIL PROTECTED]>
> Sent: Thursday, August 31, 2000 1:54 PM
> Subject: [DUG]: MS Access
>
>
> > I'm hoping someone can help me with this question.
> > I wish to deploy a D5 app that accesses a MS Access 2000 database via
ADO
> > I have no problems with the ADO part, but what considerations do I need
to
> > take when using an Access database. e.g Do I need to install the
Microsoft
> > Jet Database Engine or can I avoid using the JET engine all together.
Any
> > help most appreciated. Thanks.
> > Regards Alan
> > PS I,ve taken for granted that the client doesn't have MS Access
> installed.
> >
>
> --------------------------------------------------------------------------
> -
> > New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> > Website: http://www.delphi.org.nz
> > To UnSub, send email to: [EMAIL PROTECTED]
> > with body of "unsubscribe delphi"
> >
> >
>
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
> --------------------------------------------------------------------------
-
> New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
> Website: http://www.delphi.org.nz
> To UnSub, send email to: [EMAIL PROTECTED]
> with body of "unsubscribe delphi"
>
>
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
