Deactivate record in Access Database

I am uploading records automatically from an access database to the asp pages, but I am looking for a way to deactivate the record in the database so that it is not loaded into the asp page.

Do you know the asp code for this event?

there is no such code to "deactivate" a record.

You can delete the row from the database if you wish, or, add a column called "Activeflag" and have it as "y" or "n" and then alter your select statements so they only look at records with "y".

Add another field and call it active. Use your SQL statement to insert 1 or 0 to make that record active or inactive.

To load all active pages;
SELECT * FROM table WHERE Active =1

Exactly what I said?