VB Forum / Database Access / August 2005

I'm trying to copy data from a DBase Table (Table1 in c:\test) to
another identical dBase table in other folder(Table1 in c:\other).
(VB6, Windows XP Pro, Windows 2000)
Here is my code:

I am trying to process a large amount of data and I need to get one record
at a time. This is taking too long so I need to find a way to speed it up. I
have one recordset (from a temp table) that contains individual records. I
need to see if these records are in my live database ...

Using OLEDB to access visual foxpro DBF files in VB.NET (ultimately will
also access SQL server and Oracle tables, too).
I am trying to write a general routine that will check to see if my tables
are the most current structure.  I have successfully handled the case of

I call a SQL Server 2000 SP3 stored procedure in asynchronous mode from my
VB6 application. After completen of the sp I receive an empty recordset in
my client, although the sp returns data. I checked this in Query Analyzer
with the same paraemeters.

New to vs2005.  Trying to build a form using the data objects built by
vs2005. In my data Source window i have a dataset called FlyDataSet which
contains a table called Sales.
I have successfully used this to display data with fields on the screen but

I'm working on a project in which I retrieve a recordset from a database and
then save a local copy as an adtg file. What I'd like to do is then be able
to excute an SQL query on that recordset. Can anyone help me with the syntax
for that? It looks like I could do something like ...

I get the "Either BOF or EOF is true, or current record has been deleted.
Requested operation requires a current record." when i have loaded a listview
with records on a form. Happens when i double click on the Listview or click
the command button EDIT, which edits the record. I ...

A NEW CHALLANGE
I want to crop any size of image with 15Px border margin . please
suggest me the way to do the same  VB 6.0 i searched on VB.net but thst
is not of any use for me as i want it in VB 6.0. Any suggestions on the

sThis is a strange one. I've got a VB6 program that reads a DBF file, so far
so good. I recently changed the program to use the VFPOLEDB driver version 8
and find that in some instances it does not see any data in the table,
changing the program back to the ODBC driver and ...

I am querying a sql server db with ado.
Sometimes I receive a record in the recordset and sometimes the recordset is
empty. This is correct and as expected.
But what I want is when I receive no records I still want to retrieve the

I have a datagrid linked to a query in Access. I can use this query to
delete records from within Access but when I try to do the same from the
datagrid I get the message 'Insufficient key column information for updating
or refreshing'. However it lets me edit the records. I have ...

When I set up a Data Link to an Access database, I have a problem if the
database has a password.
I can connect if I use Microsoft OLE DB provider for ODBC Drivers but can
not when I use the Microsoft Jet 4.0 OLE DB provider.

Hello --
A datagrid, dgrCaseSiteInput, could contain as few rows as 1.  Several of
the columns are for entry.
A cmd button successfully executes a stored procedure to update the database

I asked this question a couple of days ago in a post with a
perhaps poorly worded Subject header.  It got no replies.  Let's
try again..
I maintain an Acess 2002 database table with 50,000 records with an indexed

Hello --
Is this the right group for this question?
This error appears, after many months of using the same code (below) to
connect: