ADO Data Control

  • Thread starter Thread starter Bill Morgan
  • Start date Start date
B

Bill Morgan

BACKGROUND: Access 2000 will let me add the MS ADO Data
Control 6.0 (SP4)(OLEDB) to a form. I can set up the
control's connection string and the Test Connection works
fine, and the Control's property sheet lists the
table/fields of the remote database I am connecting to. So
the Control appears to be working.

However, when I add a text box to the form, there does not
seem to be a way to bind it to the ADO Data Control, nor
does it look like the Data Control is enabled when I run
the application.

QUESTION: Am I trying to do something that Access was not
designed to do? If not, what am I missing?

The same procedure works fine in VB 6.0. (i.e., add the
Data Control, set up the connection string, bind the text
box to the Data Control, run the application, and navigate
through records).

Thanks in advance for any clarification you can provide me.

Bill Morgan
(e-mail address removed)
 
However, when I add a text box to the form, there does not
seem to be a way to bind it to the ADO Data Control, nor
does it look like the Data Control is enabled when I run
the application.

QUESTION: Am I trying to do something that Access was not
designed to do? If not, what am I missing?
Click to expand...

Yes, you are tying to do something Access was not designed to do.

You can't use the built-in controls to do this. You could perhaps try and
use ActiveX controls..and NOT the native controls, as some of them do allow
you to specify the ado data control for the data source.....but trying work
with this in ms-access is loosing battle.

You can try to bind a ado reocredset to a form (that does work). However, in
most cases when you do that..the recordset is NOT updatable.

I can't imagine you are connecting to a system that does not provide a odbc
connection...quite rare that is. Even when you have a choice between oleDB
and a plain old odbc connect...if you only have say 30 to 75 users...you
will NOT NOTICE ANY DIFFERENCE performance between a oleDB provider and odbc
when connecting to a database server.

But...anyway...if you can't setup a data source name and use linked
tables...you are using the wrong tool...

You could as a last gasp test and try binding ado reocrdssets to a
form...and then the fields will be bound to the reocrdset for you..but I
can't recommend this..as you will get some abilit to edit the data...but
when it comes to reprot time..you will be again in trouble.
 
Albert,

I figured I was on the wrong track here, but your answers
(both to this question and my previous one) have
straightened out my thinking considerably. I sincerely
appreciate your clear, thorough answers. Thanks again.
 
Back
Top