September 21, 2000

Action Queries and ADO Objects

Question: Which is better to use for inserting or updating a record: Recordset object or Command object? Answer: When using an Action Query (a query that performs an action and does not return a recordset), it is wasteful to use a Recordset object. It is much more efficient to use

Using Radio Buttons in a Form

Question: I read an article about how to search a database upon the criteria provided by users. In the example, you showed how to use a drop down menu (combo box) and a text input box. If I have radio buttons, how can I place them? Answer: To use radio

SQL Web Authentication

Question: Given that NTCR is only good in a network environment, how can I redirect a user back to a login page (or trap something) if I pass their username and password into a OLE DB connection string and use SQL authentication? When a user is not in the SQL