SQL Problem with Yes/No field in Access
Posted on 2006-07-23
I have added a column to ab Access table called "Active" and it's a Yes/No field. It's part of my test environment so I can have completed records in the database that my program will ignore, until I check the checkbox to activate the record.
Oddly it works on some tables but not others. When running in "TestMode" I add the following to each line of SQL.
" AND Active=1";
In other words I'm appending one final condition to my WHERE clause. And like I said, it works on some tables but not others. Any ideas?