Search results

Thanks, DCrake. I did try passing the tag values as individual parameters a couple of times in a couple of different ways. I did not have any luck.

Thanks, Guus2005. In past experimentation, I have put in and taken out trim(). Here is all my code. As you can see, ID23Tag has defined sizes. You are exactly right about my AddToDB function. The only differences are commented out. Below the code, is my table definition. Option Compare...

If strFileName is the only variable that has a value, then the SQL works fine. It's only the data that comes from the tag that is the problem. I'm almost sure it must be a data problem of some kind, but what kind of data problem would create a syntax error when used directly, but work fine...

Thanks for thinking about this.... Before building the strSQL string, all the fields are strings, except for Genre and Track which are bytes. The Access types are Text, except for Genre and Track, which are numbers. At one point, I tried doing a cstr on the strSQL after building the SQL, but...

The error happens on the execute and still happens when I use currentdb. I think the error must be a missing carriage return or something like that, because the problem is so weird. I'm glad you told me about currentdb, though, because I like it better than what I had. Thanks!! :-)

Hi All, I am working in ACCESS 2003 and am getting a syntax error: -2147217900 when the VBA code tries to execute strSQL using the below Function. This problem occurs only on the SQL statements that have values other than for the file name (problems are - Samy Deluxe, Black Eyed Peas, TI Paper...