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

Article View: alt.lang.vb5.rumors

Article #39

Back to alt.lang.vb5.rumors Previous Next

#39

From: 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.
;-)

Technical Details

Message-ID: <D5C0C7023F4053AA.04468AD1395996D6.A5B05FF3EABA0C92@lp.airnews.net>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

References: <DMvC4.46$sSb2.1310747@news.jazztel.es> <38DAFA67.A8A3F40C@techIII.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 104586,5f6be32c20e908c1
X-Google-Attributes: gid104586,public
X-Google-Thread: f7a67,5f6be32c20e908c1
X-Google-Attributes: gidf7a67,public
X-Google-Thread: 10ca63,5f6be32c20e908c1
X-Google-Attributes: gid10ca63,public
X-Google-Thread: 108ef4,5f6be32c20e908c1
X-Google-Attributes: gid108ef4,public
X-Google-Thread: 1131f0,5f6be32c20e908c1
X-Google-Attributes: gid1131f0,public
X-Google-Thread: 10b213,5f6be32c20e908c1
X-Google-Attributes: gid10b213,public
From: "John E. Carty" <jecarty@NOSPAMairmail.net>
Subject: Re: Control Data of VB6.0 with ACCESS 2000 database problem
Date: 2000/03/24
Message-ID: <D5C0C7023F4053AA.04468AD1395996D6.A5B05FF3EABA0C92@lp.airnews.net>
X-Deja-AN: 601912388
References: <DMvC4.46$sSb2.1310747@news.jazztel.es> <38DAFA67.A8A3F40C@techIII.com>
X-Orig-Message-ID: <8bgkvo$i0h@library1.airnews.net>
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
NNTP-Posting-Time: Fri Mar 24 14:59:37 2000
Organization: Airnews.net! at Internet America
X-MSMail-Priority: Normal
NNTP-Proxy-Relay: 204.181.96.50
Abuse-Reports-To: abuse at airmail.net to report improper postings
Newsgroups: alt.lang.vb5.rumors,hr.comp.programming.vb,microsoft.public.access.modulesdaovba,microsoft.public.vb.bugs,microsoft.public.vb.controls,microsoft.public.vb.database.dao

Reply to Parent Message