The standard DAO Data control is designed to work with the Jet 3.5 Engine, whereas Access 2000 database can be accessed only by the more recent Jet 3.6 engine. For
Date variables store values in floating point format, much like Double variables, with the integer part for dates and the fractional part for the time portion. Being floating point values,
If your ASP pages display strings stored in database fields, you should always process the strings with the Server.HTMLEncode method, otherwise the string won’t be displayed correctly in the user’s
After you install Visual Basic and log on to the machine as a different user (with or without administrator privileges), you cannot see any Add-Ins in the Add-In dialog in
Have you ever read a message like “Dependency file for COMCTL32.OCX is out of date” during the package creation process? The cause of this problem is simple: you have installed
When you assign a reference to a form (or one of its controls) to an object variable which is stored outside the form module, you must set the variable to
If you instantiate an ActiveX component from an ASP script under IIS 4 and previous versions, using the Server.CreateObject command, you might believe that the object is deallocated as soon
A SELECT query returns all the rows for which the WHERE clause returns True. However, many developer – especially those accustomed to other programming languages, such as VB – get
In SQL Server 6.5 and previous versions, the GROUP BY clause in a SELECT statement was carried out by temporarily sorting the resultset before grouping similar rows, therefore the end