VB Forum / Database Access / October 2006

In vb6 project where i'm using an mdi interface where should i instantiate
the connection and recordset objects and clean them up? suppose i write a
clean up code in command button then how can i force a user to click the exit
button everytime before opening the next form?

I am writing a VB6 App using an Access database backend (not clever but cheap!)
Yesterday the performance of data access became unacceptably slow, from near
instantaneous to 10 seconds to retrieve 4 records to fill a datagrid.
It happened after I had added a new table to fill a ...

I have a disconnected Rs.
Pre - updatebatch
When I loop the Rs is there a way to detect if a row
has been previously been deleted so I can movenext & skip past it.

How can I call a visual foxpro 6.0 program in VB 6.0 and access VFP free
tables in VB programs to update those ?
If anyone has any sample programs that would be great.
thanks

I have been fighting with this for a couple days.
I need to return a number from a Sybase SQLAnywhere(9) stored procedure
which has one In parameter (string) and one Out (integer).
I'm calling it from a Outlook Com addin (VB6).

Greetings all, sorry if I over do with the cross posts...
I've prowled around in all the places I can think of trying to find a
way to send and receive (that's the tricky part) PJL commands and
responses to printers connected direcly to a computer via USB or

We have a client and server application that run on the same machine.
We want both to participate in the same transaction.
To acheive this I understand they need to share the same connection
object.

I'm thoroughly confused.
The following expression works fine as a table view rowfilter when locale is
set to US.
dateField <= "#" & Now.ToShortDateString & "#"