No read access with Access & ADODC

[Spooner]

I made a database in Access97, and made sure everyone's got all rights.

Then I put an adodc control in a VB app and used Jet to connect to a table in the db- test connection works. Then I put in a text box to bind to one of the fields. But I can't databind the text box to any of the fields in the db. I put the adodc in as the text box's data source, but when I click on the text box's data field property down arrow, I get the message "Records can't be read; no read permission on Addresses".

I've tried Jet3.51 and 4. The connection string by the way, is:

Provider=Microsoft.Jet.OLEDB.3.51;Persist Security Info=False;Data Source=D:\Address Book1.mdb

I've quintuple checked the permissions in Access.... what am I doing wrong?

[Beacon]

Top thread ADO tutorial.
Dump the control and use ADODB. There's no need for the control.

The error has something to do with the connection string.
Adlockreadonly i suspect!
You'll understand after you read the tutorial.

b

[jkcontra]

I agree with Beacon, dont use the ADO Data control, but if you want to use it, when you build the connection string, go to the advanced tab, and set your read write mode settings.