I have a datagrid with the datasource linked to an ADODC. I had the Adodc set up through the properties when I first set it up (I do not know why I did this). I now have changed it to set programically. Now i am getting a "could not find installable Isam" error. I went to connectionstrings.com and as far as I can see, i am doing it correctly.
Expand|Select|Wrap|Line Numbers
- adoEvents.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & App.Path & "\work2.mdb;Jet OLEDB: Database Password = sgsd"
- adoEvents.RecordSource = "Select * from tbltempevents"
- adoEvents.Refresh
I have tried the password in single quotes and without quotes.
Please help
Andrew