Re: ADO Data Control Error Message "Unexpected end of statement"

When i bring up the properties on the Data Control is lists several DB
Providers but none for Jet 4. How can get that ?

--
John


"Val Mazur (MVP)" wrote:

> Hi,
>
> Are you using Jet 4.0 OLEDB Provider? This is what you need to use to
> connect to Access
>
> --
> Val Mazur
> Microsoft MVP
>
> http://xport.mvps.org
>
>
>
> "John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:276B8BD8-C040-4508-805F-595F50A0A303@xxxxxxxxxxxxxxxx
> >I am using VB6 & Access 2002. I have a vb form with various text boxes and
> >an
> > ado data control. When i try to link the data control to the access table
> > i
> > keep getting the following message window: Adodc1 - "Unexpected end of
> > statement".
> > I think i am using the wrong criteria in the Data Link Properties. Is
> > there
> > a specific DB Provider i should be using? It does not list any specific
> > one
> > for Access.
> > Any help appreciated.
> > --
> > John
>
>
>
.

Relevant Pages

  • Re: VB + Acess 2000 Question
    ... Are you using the Jet 4.0 provider? ... Al Reid ... > Put data control on the form, ... > It pop up a message, not recongize database format. ...
    (microsoft.public.vb.database)
  • Re: JET 3.51(Data Control)
    ... Cannot Connect Data Control to a Password Protected MDB ... The second article doesn't provide a work-around, but the one in the first article *should* apply to Jet 3.51 too, I'd think. ...
    (microsoft.public.vb.general.discussion)
  • Re: Data Control
    ... > data control to perform much of its functionality if I assign the data ... but I can't refresh or do some other things without VB ... I do not believe that VB5 was ever updated to be compatible with Jet 4.0. ...
    (microsoft.public.vb.controls)