VB Forum / Database Access / July 2004

I am trying to change the Field Description in an Access App. with
linked tables (SQL). The reason is because we have many tables and
each table has more than 100 fields and it would take forever to copy
the description from original Access database to the SQL Linked Table

SQL Server 7 and VB 6.
We have a database and on this database an application is performing
transactions. This might involve editing a sales order. The application
starts

I am using VB 6, ADO 2.1 and Access 2000 database.
I  have a text file with about 50,000 records which are to be entered
into a database. The text
file cannot be exported directly to Access database as I have to do

I have a problem with some code which is creating the following OLEDB error
message.
Run-time error: -2147217864 (80040e38)
The specified row could not be located for updating.  Some values may have

I have created a ADODB recordset with data taken from a SQL 2000 table. I have made changes to some of the data, but when i try the following
private sub UpdateDB
On Error GoTo ErrTrap:
 If mbDataChanged Then

I'm looking for solutions to notify a client when a database change
occurs.  I've read numerous threads here in the Newsgroups, but I
really haven't found what I thought would be the total solution.
I have a Windows application written in VB6 (currently upgrading to

How do you remove duplicate records within a table using an SQL Statement?
I have a column in a table that contains 300,000 records.  The records are
composed of one field.  The field contains 9 digits, ie: '123456789'.   You
might have more than one duplicate of the numbers.

Hello together.
I have a big problem distributing a VB6 application.
I created a package with all the needed files, but after installation
the program crashes at startup with the following error message:

Is there a way to get multiple inserts into the database, i have some issues
regarding ADO.updatebatch and I am looking for some way to work around. I
can use ADO.Update but it would be slow as it would do 1 records at a time.
I am using VB6+VFP7

in DAO we used to do this to make Master Details relation in one form
Private Sub Data1_Reposition()
 On Error Resume Next
 Data2.RecordSource = "SELECT * FROM Sales WHERE CustomerID = " &

I am trying to move to ADO from DAO and would like to know about which way
is better regarding the connection?
that is to have ONE global connection and use it all the time and only close
it when the program close

I wonder if anyone can help. I am just starting out with VB6 and have
created an application with and MDI layout and now wish to show a
dialog box with several options for the user to choose prior to
continuing operation of the calling form.

My VB program need to force all connections to a MS Access 2000 file to close.
Therefore, my VB program can compact the Access file.
Is there any way I can force all connection to close?
Best regards

This is an annoying problem and one that has confused me.
I have opened a database connection of a access database
through the PROVIDER=MSDataShape.
Main Table

What is the error that is thrown by ADO 2.6  in VB 6.0 when you try to
access a row that is locked by another user?
Does the error appear in the VB Err object or does it appear in the ADO
Connection's Error Collection?