VB Forum / Database Access / May 2004

Does anyone recommend a book discussing MySQL programming using VB6?

What would I need to do to distribute msde with a vb app.  Is there a way of
including the msde files with the vb installation files?
Daniel

Using Oracle 9 OLEDB Provider. we have error with following test code
  Set loCon = goCo
  loCon.BeginTran
     loCon.Execute "insert into mwcMenuItems(ID) values (666)

I posted a message earlier concerning attaching to a VFP 8 directory as a database.  I was able to do so but my ADO knowledge is limited
I was able to open a dbf in ADO courtesy of Cind
           con.ConnectionString =
               "Data Source=" & dbfPath & ";" &

Using VB6, how would I make a drop down or combo box appear when the user
clicks on an empty row in a grid?  Which grid is best to use?  the plan is
to have a dropdown display parts and when 1 is selected will fill grid with
part info and then the user can enter the number of parts ...

if i just open with editor real one .udl file (308  kb) and make program for making file with the same text and same extension , file will be 106 kb , and just don't work. I tnink problem is in properties of file but i don't know how to setup properties like connection ...
create  ...

I have i smple problem
I want to perform a query that containst path as table name.
Problem is when the path contains spaces
Example:

I have one important question:
It so so easy to make powerful and fast queries on an access db,
but how can I write data more easily in a certain bd design ?
Do I always have to use the ordner of the data structure when I use

I want to be able to upload an Image from a form to a file server. I want to input the name of the file an Access database. How can I do this?

Is there anything similar to "<input type="file">" for a visual basic form? I want to be able to grab the location of a file.

can anyone  help me out with error in the following cod
Set DB = OpenDatabase(path & FOffertDB.Value
regard
uk

The following query has failed to return all the records.
SELECT b.Account_desc, b.Account,
IIf(a.source_type = 'LY01', a.CSPL_CSPL,0), IIf(a.source_type = 'LY01',
a.CSPL_CMS,0), IIf(a.source_type = 'LY01', a.CSPL_CMM,0),

I created a database using VisData and want to change the size of several fields.  In it six fields
have Size = 50.  How do I use VisData or SQL to change each of those fields to Size = 150 or more?
When I click on "Design", the Size block is not enabled - faint in color.  Although ...

Hi Group,
VB6 and Access 2002.
In VB, on form frmData, I have comboboxes with style property set to
vbComboDrop-DownList.  I like this style and don't want to change it.  There

I have three recordsets opened from an SQL database.  The common field for
all three is ID.  I open each recordset with Cursorlocation = client,
CursorType = OpenDynamic, LockType = Optimistic.
Recordset one is Master with 17,000 records.