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

Hi,

You could install Jet 4.0 downloading Jet 4.0 SP8. But you should be aware
that it is platform-specific. Check it here

http://www.microsoft.com/downloads/results.aspx?freetext=Jet+4.0&productID=&DisplayLang=en

--
Val Mazur
Microsoft MVP

http://xport.mvps.org



"John" <John@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1EFB46A0-F281-47FB-8886-8EE5028E2807@xxxxxxxxxxxxxxxx
> 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