Using the Data Control with Access 2000

[David Laplante]

Hi.
I noticed that the Data Control cannot work with Access 2000 databases unless you set the data control content by code.

This method works pretty well, but for some reasons, I cannot go with this solution.

I want to know if there is any data control version that will allow me to use Access 2000 tables, normally, at design time. (Just like the older DAO)

[JHausmann]

Are you using the DAO 3.6 Object Library?

[David Laplante]

Yes I am using the DAO 3.6 Object Library.
Using this library works pretty well with Access 2000 databases, like I said, but only with CODE attached to the data control. (populating a recordset and setting it to the data control)

I want a data control that works just like the one using DAO 3.51. Is there such a thing?

[Clunietp]

In the form_load of the form with the data control, add this code (while still referencing the DAO 3.6 library)

Dim DB as database
dim rs as recordset
set db = dbengine.opendatabase("c:\database.mdb")
set rs = db.execute (SQLorTableNameHere)

set data1.recordset = rs 'name of data control

I think that is all, I could not test that code but I have done something similar before. You should have all the functionality of the data control after that.

HTH

Tom

[David Laplante]

I know that works but this way I would have to set the data field of all my control in code right? A little anoying don't you think?

[Clunietp]

You could manually type them in at design time as long as you know the names of the fields (because you can't get the field names at design time with that dropdown but you can use the data view/link window to get them)

Tom

[David Laplante]

I am starting to wonder what I should do. I want to make a database app and I have very good experience using Ms-Access... but the run time files are too big (100megs) cuz I want people to be able to download a evaluaion copy from the net.
I gess VB's run time files a much smaller but I feel like a newbie when I can't even display information in my access 2000 mdb file...
What do you think? how big is the vb6 run time?

[Clunietp]

The VB runtime is about 1.4 MB, but it has other files that need to be updated like oleaut32.dll, and some others. You can download the complete runtime set (less than 2mb i believe) but that is alot less than 100 MB. Don't forget, when using DAO you have to redistribute the DAO runtimes as well...