Tip Bank

Question: I’m trying to install a search facility on a database program I have written using VB6 and an Access database. I’ve opened by inserting a data control onto my

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