Control Data of VB6.0 with ACCESS 2000 database problem

Thread View: alt.lang.vb5.rumors

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by plozano Thu, 23 Mar 2000 00:00

#40

Author: plozano
Date: Thu, 23 Mar 2000 00:00

15 lines
1792 bytes

When I use a Control Data of Visual Basic 6.0 and I try to open an ACCESS
2000 database, the program respond with the error:
I can't to recognize the format of DATABASE "c:\... "

    The data properties are the next ones:
        .Connect = Access
        .DatabaseName = "Path"
     The error occurs when I try to open the Recordsource property


Someone know why?
It is possible to solve it ?


Thanks you very much

Re: Control Data of VB6.0 with ACCESS 2000 database problem

#41

Author: Richard
Date: Thu, 23 Mar 2000 00:00

35 lines
2065 bytes

You have to:

1 Change the Project Reference from MS DAO 3.5 to MS DAO 3.6
2 Change your code to have:

dim RS as DAO.recordset    '(You might have DIM RS as recordset now)
' Your open database assignment goes here, or if you don't have one:
     ' set YourDatabaseHere = dbEngine(0).opendatabase(YourPathAndFileHere)
set RS  = YourDatabaseHere.Openrecordset("YourTableHere",dbOpenDynaset)
set YourDataControlHere.recordset = RS


plozano wrote:

> When I use a Control Data of Visual Basic 6.0 and I try to open an ACCESS
> 2000 database, the program respond with the error:
> I can't to recognize the format of DATABASE "c:\... "
>
>     The data properties are the next ones:
>         .Connect = Access
>         .DatabaseName = "Path"
>      The error occurs when I try to open the Recordsource property
>
> Someone know why?
> It is possible to solve it ?
>
> Thanks you very much

--



.....................
Richard Grossman
rgrossman@techIII.com

Re: Control Data of VB6.0 with ACCESS 2000 database problem

#39

Author: John E. Carty
Date: Fri, 24 Mar 2000 00:00

45 lines
2693 bytes

"Richard" <programmer1@techIII.com> wrote in message
news:38DAFA67.A8A3F40C@techIII.com...
> You have to:
>
> 1 Change the Project Reference from MS DAO 3.5 to MS DAO 3.6
> 2 Change your code to have:
>
> dim RS as DAO.recordset    '(You might have DIM RS as recordset now)
> ' Your open database assignment goes here, or if you don't have one:
>      ' set YourDatabaseHere =
dbEngine(0).opendatabase(YourPathAndFileHere)
> set RS  = YourDatabaseHere.Openrecordset("YourTableHere",dbOpenDynaset)
> set YourDataControlHere.recordset = RS
>
>
> plozano wrote:
>
> > When I use a Control Data of Visual Basic 6.0 and I try to open an
ACCESS
> > 2000 database, the program respond with the error:
> > I can't to recognize the format of DATABASE "c:\... "
> >
> >     The data properties are the next ones:
> >         .Connect = Access
> >         .DatabaseName = "Path"
> >      The error occurs when I try to open the Recordsource property
> >
> > Someone know why?
> > It is possible to solve it ?
> >
> > Thanks you very much
>
> --
>
>
>
> .....................
> Richard Grossman
> rgrossman@techIII.com
>

You'll also have to hand-type the field name in the DataField property box
as trying to use the drop-down list will also return an error. Kinda sucks.
;-)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads