VB Forum / Database Access / February 2006

I have a dataset with relationships between the tables in it. I deleted a
row which had child rows associated to it. I did this in a try...catch block
expecting an exception but didn't get one! This action should throw an
exception shouldn't it? Can anybody help?

I am using VB 6.0 and want to connect to a paradox 4.x table and put that
data in a data grid.  The table is on our company server; so my path to is
\\[servername]\[program name]\[subdirectory]\[Table].
I put the Micorsoft Data Grid Control 6.0 on the form...and an ADO Data

Is it possible to get at list of the databases on the MySQL-server in VB 6.0
using MyODBC.
JCLarsen

I'm hoping someone will be able to help me.  I am currently developing
an automated Word document .  I am at the stage where I want to have
the information that is entered into the userform to populate fields in
an Access database.  The userform has been created in Word VBA.  I

In a VB program I allow the user to call the calculator within the system on
my PC this is located in C:\I386\CALC.EXE but I have found on other computers
it lives in differant sub files. Is there a way to write this syntax to seach
all possible locations?

I am writing a program in VB to convert DBF to SQL server database.
I wanted to know how can I make sure that database I am using is
DBASE IV or FOXPRO.
Thanks

I'm having problem locking a table in Ms Access using VB6 code.
Actually I have 3 tables.
Assume table names is A, B, C.
Following is the process.

From what I've been told, there are basically two ways to access a database.
1)
a) Make the connection when the program starts
b) Leave the connection opens at all time

Some questions from a newbie
I need to update records in a SQL database (In network) with information
coming from an excel sheet using ADO
what would be the best way to do this causing the minimum overhead to the

Hi and thanks in advance for any help
I wish to load from an Access DB a list of names i.e Cat, Dog etc and place
those names randomlly in a text box.
That is whwn a text box clears another name will appear

I am converting an Access 97 app to VB 6 and wondered what is/are the best
controls to use to be able to recreate Access-like reports without the Access
engine.
The new VB 6 app will be installed on some older PC's, so resources will be

using vb6, adodb, mdb file format (no access)
I think I've created a table with the following function...
Option Explicit
Function CreateJobTableSQL(oRefConn As ADODB.Connection) As Boolean

In VB6 code I have been able use DAO to open two MS Access 2003 databases.  I
have also been able to read records from specified tables.  Without coping
each record at a time, How do get into my database a copy of table from the
other database.

In a VB program I allow the user to call the calculator within the system on
my PC this is located in C:\I386\CALC.EXE but I have found on other computers
it lives in differant sub files. Is there a way to write this syntax to seach
all possible locations?

I am using VB to create a converter for DBF to SQL.
I am using ADODB Connection in my code.
Now, I need to find how I can get the column attributes
from the database.