VB Forum / Database Access / October 2006

Can anyone tell me how to set the refresh interval on a Jet 4 mdb from VB6?
If it's exposed anywhere other than the Access UI, I haven't found it.

I have a Access97 Database and if I delete all the records compat the
database when I use AddNew I get an error message Runtime Error '3426': This
action was cancelled by an associated object. and highlights the
Data1.recodset.AddNew line in the command button event.

I have 3 tables in an Access 2000 DB.
C_List
  CID
  Name

What is the correct code to use if you need to copy table "X" from database
"B.MDB" into "A.MDB" .
I've seen this before but don't remember the correct syntax.

I am opening a recordset (select query) through an ADODB.Command object
in VB6. The user may abort the recordset reading at any moment; if that
happens, I cleanup all relevant objects, close the recordset and exit.
The problem is, that the time it takes to close the recordset seems ...

In my VB6 program, the statement of "g_MyRecordSet.Find strCriteria" causes
the following error:
"Rowset does not support scrolling backward"
The recordset is populated by calling an Oracle 9i stored procedure with ref

I have a VB6 application that was extracting data from an 8i DB but we
recently upgraded to Oracle 9i and started having problems with the
Oracle ODBC driver (v9.2.0.1.0).  We kept getting an error when trying
to create the connection to the DB but ther was no Oracle refused to

I am trying to change a select, find duplicates, query into a delete
query.  I want to get rid of the records in the main table
"tblHurnsHistory."  I changed the Find Duplicates query to a Delete
query.  I then received an input box looking for criteria that

I have a SQL table comprised of 31 columns.
The first column is simply an id column, the next  30 columns are labelled
[1],[2]...[30].
The numerical columns have a tinyint type and the data stored is either 1 or

I have an Access form with a TabControl object containing 4 pages.
I have set the tab order for the controls during design time.
This works fine.  Now I want to change the tab order for one
of the pages at runtime at certain events.

Good Day!
Would be appreciate if there is solution for the following problem:
- In VB.Net of Visual Studio.Net 2003, developer can click and drag a table
listed in the Server Explorer from a connected database to the form. This

I need to make a row from a spreadsheet unique. I do not have control
over the data in the spreadsheet. I just process it in my VB code as a
recordset.
Is there any way to get the row number from an excel spreadsheet? Or is

What is the recommended way to generate a list of available SQL servers so
that I can allow user to select one from a drop down?  I see that
app.listavailablesqlservers is no longer recommended.  I also need to
generate a list of available databases once the server is selected ...

I have 2 access db that I need to connect with using my VB application.
My question is can I connect with one db to read the data from a table
and then update into another table that is in another db, another
location?

I have a VB6 app that copies data into a "Reports" database (Access97) and
then calls code within that database that runs a couple of queries and then
displays data in a report.
Our organisation has recently had it's hardware upgraded to XP from NT and