VB Forum / Database Access / December 2004

When I close my application (in VB6 with Access 2000), I still have
processes runnning.
Actually, it only occurs when I print a report, otherwise the application
ends normally when I close the last window.

...while trying to open an Access 97 .mdb file with an MFC (MSVC 6.0) app
using CDaoDatabase classes.  The really odd thing is that I have other apps,
written with _extremely_ similar code, that happily open _extremely_ similar
databases, on the same machine.  This app works on some ...

I use VB6 with ADO and SQLserver.
I have a recordset (CursorLocation=adUseServer) returning 300000/400000
rows.
If I scroll the recordset using .movenext, I take more time... I need

We have an application that uses a paradox database. In order to
create managemet information, we need to connect to this database from
Oracle Warehouse Builder, either through an ODBC connection or link
the tables first in an Access database. Has anyone experience with

My vb-application uses DAO to access data in an Access 2000 database. Is it
possible to change the database password programmatically ?
Thanks for your efforts.
Klaus

I'm using ado and an ms-access 2000 database. I need to cycle through
all of the tables and check whether or not a particular field exists in
that table or not (the same fieldname in each table). If it does I need
to write the table name to an array (this part I can do).

It's possible to use Print Preview in Visual Basic? If the answer is Yes,
please can give me information or where I can found it's?
Thanks, Iván

I'm using net send to send and recive messages in a LAN....
When I recive a message a window appears with the name of the sender
and the text of the message, but i would like to intercept this window and
put

I have a table i need to know the syntax that represents the name of
the link.  In link table manager you would see tablename  (C:\something.mdb)
If the the table is and attached table
  For Each tdfLinkCheck In .TableDefs

I made the exe program for the VB , but when it run on
another computer, there is an error message
'Run-time error '339':
Component 'MSDATLST.OCX' or one of its dependencies not

I have a Dynamic Data Report which pulls data from a stored procedure,
When report is view it always skips the first record
I have tried everything I know
Here is the code:

Hello everyone. I am working on a project that must send new records (not
updates) to a "main" system on a periodic basis. The "remote" system uses VB6
and ADO to retreive the tables and uses the "adoPersistXML" option to output
to XML. Once all of the tables are output we use a ...

Hello - I have a VB6 application that I would like to create a SETUP program
for using Inno.  The question I have is that my application requires the
ability to upgrade a SQL Server database, if needed, depending on the nature
of the upgrade.  I realize I can use SQLDMO to ...

i have a connection to a SQL2000 server ( below) and want to run an Insert
query against a table.
' connection
  Dim conn As New ADODB.Connection

Hello -- I have a login form that I'm creating to SQL Server.
I've decided that I do not wish to use DMO at this time to display a list of
servers and/or databases.
I have therefore added a textbox for servername, username, and password.