could not find installabe Isam

[rudeman76]

Hi,

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 connectionstrin gs.com and as far as I can see, i am doing it correctly.

    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

When i press ok on the error, it brings me to the adoEvents.refre sh line.

I have tried the password in single quotes and without quotes.

Please help
Andrew

[rudeman76]

I have tried different aproaches to this. It seems as soon as I add a password to the DB it dont work. Can anyone help me please

[rudeman76]

hi all,

I figured it out. I had: Jet OLEDB: Database Password = sgsd
it should have been: Jet OLEDB:Database Password = sgsd

no space after OLEDB:

Amazing how much headache a space in a wrong spot can cause

Andrew