Problem with ADODB.Connection and Insert Command

Hi everyone!

I can not understand why this code does not work.
SQLString = insert into Positions (FundName,SubFund,Prime_Broker_Clearing_Broker) Values ('A','A_AA','WW') , where Values are just strings. I tried different combinations, but it didn't work.
SQLConnection(DBSource) - This function sets connection, it works properly I checked with other simle task, i can extract the last date from DB

In my case iRecAffected is always 0.

Please Login or Register  to view this content.

Thank you for your help!

Can you post the rest of the code?

What are the data types of the field you are updating?

What database are you connecting to?

Hi, Norie
thank you for your answer. The whole code is really big. First I read the data from Excel and build up SQLStrings.
SQLStrings are correct, they contain just fields and values.
There is the function which establishes connection.

Please Login or Register  to view this content.

DBSource is the path to Access database.

Thanks!

It's kind of the part that builds the SQL that I wanted to see.

You say they are correct?

Did you check them in the database?

Yes, it is just the function that returns strings and they look like this:

SQLString = insert into Positions (FundName,SubFund,Prime_Broker_Clearing_Broker) Values ('A','A_AA','WW') (I printed it in excel file so I am sure it looks like this)

and then this string is passed to Sub SQLCommand(SQLString As String, DBSource As String) together with the path to the DB.

The funny thing that the database was working till some day in August and since that time no updates were made because of this technical reason.
And now my task is to figure out why...I checked every function and I am puzzled. But I have never worked with this stuff before, so I used some internet tutorials and according to them it should work..so I guess I am missing something important here..

I will try, thank you!

May be you could advise me some manual/tutorials in internet, so I can learn more about ADODB, etc...
I will really appreciate.