adodb recordset - Access Developer Forum


	Back to Access Developer Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

adodb recordset

Robert Holland

4 years ago

I have an open statement that works using a sql string as the source. If I add a new field to the table that the sql statement queries and also add the field to the sql statement, the new sql statement cannot find the field. I have check the spelling - no problem there. Similarly, if I add a new table to the database, the engine cannot find it. Is this a bug or me?

	Scott Axton @Reply 4 years ago
More than likely it is you. What is your table? What field did you add? What is your SQL statement? If you are designing tables while editing code Access may not update. That is why you see Richard consistently Save, Close, and Re-open forms. So that all of the new changes are loaded fresh and memory is re-set.

	Robert Holland OP @Reply 4 years ago
Sott ; Yes - I was editing and changing tables at the same time. I did test of your hypothesis with close attention to closing before running - and as you proposed - the problem was fixed. Thanks so much. You saved me hours of frustated puzzlement. Thx RH

	Scott Axton @Reply 4 years ago
Robert - That's GREAT! Glad it helped. Many times it is the little things and why that get missed in the videos.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.

Next Unseen

New Feature: Comment Live View