Different from Access and SQLServer queries in ASP

To query if it is ISUSE is a true condition in Access, you can use it directly in Access.

Rs.Open "Select * from classroom where isuse", conn, 1, 1

And the database is not used when SQL Server

Rs.Open "Select * from classroom where isuse = 1", conn, 1, 1

Talented