Suppose you have two tables named Table1 and Table2 with one or more fields named the same way. Now, consider this query: rs.Open “SELECT * FROM table1 INNER JOIN table2
If you try to use a DataList and some labels or text boxes linked to an ADO Data control, and you click on some items in the list, you’ll notice
When working with a forward-only, read-only Recordset – that is, the default ADO Recordset – the RecordCount property always returns -1. (This can also happen with other types of server-side
A file DSN is nothing but a text file that contains all the parameters for an ODBC connection. To prove this, just go to the default directory that holds all
The syntax for opening a password-protected Jet database might not be obvious. In fact, assigning the password to the Password property in the ConnectionString raises the following error: Run-time Error:
Here is a little tip to check if any of your .class files are corrupted or if they are not .class files generated from a .java file. There
You can connect a MS-Access database to SQL Server as a linked server, and query Access tables in SQL Server’s Query Analyzer. This can help in porting data from Access
LIKE is probably the VB operator is most underutilized if compared to its potential. The most immediate use for this operator is to check that a string begins or ends
Constructor is a special kind of method which gets called automatically whenever the object is created. One class can have zero, 1 or more then 1constructors. Basically, you can overload