VB Forum / Database Access / May 2006

I'm using OpenDatabase function to connect the database, When I look at
the Task Manager the handle count get incremented by 6 (i.e. from 86 to
91) after the OpenDatabase function gets executed.
But after calling the CloseDatabase function the handle count get

I'm creating a simple application that uses a DataGridView in a form to show
records originating in a Sql database.  I have two questions related to
keeping the data current and synchronized between the DataGridView and the
Sql database.

I'm getting confused between VBA and VB 6.  Can someone tell me how to
create a group of option buttons in a frame; the value of which I can insert
into an Access database?
I assume I have to create the frame first and then put the buttons in.  

i am importing excel data through a web form, using ADOX.
i only want to grab the first worksheet, but unfortunately if the user
re-arranges the worksheets in the excel file, the ADOX Catalog.Tables
collection still presents the tables in the original order of the

I have an applicatiuon which (for reason's I'm not going to go into)
uses two database formats - the primary data is stored in a Jet
Database (MSA97) and additional data is stored in a dBase5 database
What I need to write is a query which will pull in one table from each

am a freelancer. In the past I worked on different projects so I have
wide field of specialization from system projects( written using
Windows API ) to UI projects. Worked on realization of 3-tier
architecture in UI applications(Windows forms and Asp.Net

At some point an index has been added to a table in my Access DB that
does not allow duplicates.  I can't see where I ever put an index on
this field.
But, when I tried to add 2nd records with a duplicate value in the 2nd

I'm using simple data controls to connect to an acces database.
#1.i'm getting error of operator missing for following code line
   data1.recordsource="select * from table1 where name='"& text1.text
&"'"

I am developing an application using VB 6 with Access as a database.
Having a problem at one terminal where during cooect to the database (during
login), system prompt an error message "Microsoft [ODBC Driver
Manager].Driver SQLSetConnectAttr Failed"

Hello all you smart people out there.
I need to find a way to use VB6 and ADO to store .DOC .XLS .PDF, etc files
within SQL Server in a BLOB field.  I know it's possible as Sharepoint does
it automatically into MSDE and SQL Server.

I have a SQL Server database with gif images stored in a nText field as
binary. I've been asked to export these images to actual gif files
(about 250 of them). I found a stored procedure that was using some ADO
and it would write a small part of the image correctly and then the

I have a form with three data grids on it; each of which is bound to a
dataset. These grids are all related such that the first is the parent to the
second and the second is a parent to the third. During runtime if the user
makes changes or additions that duplicate an existing ...

I'm trying to design contact (names and addresses) tables in an Access
database.  Some of the contacts represent vendors, some are board members of
the organization, some are donors, some are neighbors of the organization,
some are politicians, etc.  Rather than create separate ...

Hello.  I have an application written in Visual Basic 6.0 that uses a
Microsoft Access 2000 database.  The application creates all the tables and
columns automatically using ADOX.
I have a particular column that is a number, specifically a decimal with

I am using VB6 have mdac 8 SP1 and Jet 4.0. I build an update statement with
a yes/no field as part of the where clause. When I run it it returns Run-Time
Error '-2147217913 (80040e07)' Data type mismatch in criteria expression.
If I debug print the statement and paste it into MS ...