Run VB code, no error messages, no data in the table.
Run sql statement in query window - no errors, no data. column count is ok. no restrictions on the table, no primary keys, table has only text fields. Original apps has no problem running code. The only changes that were made are added columns in the table and accordingly in the sql statement.
I'm at the end of my wit here, so any ideas will be greatly appreciated.