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

Article View: alt.lang.vb5.rumors

Article #41

Back to alt.lang.vb5.rumors Previous Next

#41

From: 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

Technical Details

Message-ID: <38DAFA67.A8A3F40C@techIII.com>

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

References: <DMvC4.46$sSb2.1310747@news.jazztel.es>

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: 10b213,5f6be32c20e908c1
X-Google-Attributes: gid10b213,public
X-Google-Thread: 108ef4,5f6be32c20e908c1
X-Google-Attributes: gid108ef4,public
X-Google-Thread: f7a67,5f6be32c20e908c1
X-Google-Attributes: gidf7a67,public
X-Google-Thread: 10ca63,5f6be32c20e908c1
X-Google-Attributes: gid10ca63,public
X-Google-Thread: 1131f0,5f6be32c20e908c1
X-Google-Attributes: gid1131f0,public
From: Richard <programmer1@techIII.com>
Subject: Re: Control Data of VB6.0 with ACCESS 2000 database problem
Date: 2000/03/23
Message-ID: <38DAFA67.A8A3F40C@techIII.com>
X-Deja-AN: 601628710
Content-Transfer-Encoding: 7bit
References: <DMvC4.46$sSb2.1310747@news.jazztel.es>
X-Accept-Language: en
Content-Type: text/plain; charset=us-ascii
MIME-Version: 1.0
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