VB Forum / Database Access / July 2005

I'm doing some maintenance on an old project that uses VB6 as a front-end to
Access97. When the application closes it leaves behind an .ldb file with a
few locked tables in the database.
So far, I've been tracking the problem by ensuring all queries, tables, and

I am using visual basic and microsoft sql server at my software
development. Recently I started to use stored procedures. Because
stored procedures stay in database, I don't have to create them every
time (create an drop them), right?

I am creating a data report in VB 6.0 and Access DB.  Each Record in the
Access DB will have it's own page in the Data Report.  Data varies from
record to record.
For instance the report design may look like:

     Autonumber
    Convert From
    Convert To
    Conversion Multiple

I'm doing some maintenance on an old project that uses VB6 as a front-end to
Access97. When the application closes it leaves behind an .ldb file with a
few locked tables in the database.
So far, I've been tracking the problem by ensuring all queries, tables, and

Is it possible to open a connection in code, say a Public Module then have
that proc called and pass back the connection object when its called.
Guess what I am asking is: can I set my connection once and have it
available throughout my app?

I am trying to add a record to a table in access from my VB6 application
using ADO
The values I am using for the new record are taken from a number of combo
boxes and a list box on a form. I have put the following code in the

Please say frind ?
which connecton is speedy ? adodc  or by code ?

Is there a way to create a database in runtime using ADO?
thanks,
Ramon.

Hi' there !
My situation is this; My customer have a hole bunch of different Excel
workbooks - with VB code inside. In this VB code the user/pwd to the ODBC
connection is hardcoded. This hardcoding is not approved by audit.

Hello --
In the course of building the app I created many menus and submenus and
later deleted many of those.
I want to clean up the code and remove menu "stubs" like

Just transitioning from Access Developer and running into the wall
everywhere with VB6. Not least being the connection of data in/between
controls. I am building a basic Measurement Conversion Form, it has three
fields (all of which are datacombo's) and two tables feeding them.

I'm switching over to ADO from DAO and was hoping someone could give me a
working example of how to pass a value to an Access 97 query via ADO.
Specifically, here's what I need to do:
I have a query called qryGetOrder with a parameter named "Order #" in an

Using VB.NET and SQL Server 2000...
I have a combobox who's dropdownstyle member is set to dropdownlist.  
Can someone tell me how to get the displaymember member to show the
expression 'name' in this query that is setup in the data adapter?  All of