VB Forum / Database Access / March 2005

Dear Friends,
I am trying to executeNonQuery() using a string that has a semicolon in
it.  Is there anyway to escape the simicolon so the execute dosent
think it is the end of the statement?

What is error 381?
Thank you,
Jim Y

I have questions stored in an access database, some with images.
I have used a datacontrol to show the questions on a form in VB6 and used an
OLE container control to display the image (I dont know if there is another
way to do this). I now wish users to be able to change images on ...

Dear sir,
I AM A VB DEVELOPER 6.0, I AM USING DBASE(IV) DATABASE THROUGH DAO. I OPEN A
DATABASE BUT WHEN I OPEN DATABASE RECRODSET BY ORDER GIVE A RUN TIME
ERROR!!!

Hello all,
Have a weird problem here. I'm trying to use an OleDbDataAdapter to connect
to an Access database, but
I get this message when the wizard runs its course:

I am using following connection string to get data from a .csv file using
vb.net
strConnstr = "Driver={Microsoft Text Driver (*.txt; *.csv)};Dbq=" +
System.IO.Path.GetDirectoryName(sFileName) + ";"

I found a way around my problem.
I changed the field names (abbreviations) and now the data adapter is
connecting to the tables and creating the data sets.
This gives me a quick fix, but it would still be interesting to know the

I get the following exception when the user clicks the cancel button in the
Data Link Properties dialog.
Object variable or With block variable not set.
The code I am using is:

I upgraded my development machine to W2k which caused to upgrade to ADO
v6 and MDAC 2.5
However my application is deployed in older W98 machines and EXE's
produced from W2k generate error 430 automation error unless they

Does anyone know of a web site with a tutorial that walks you through
manipulating an Access database using ADO programmatically? I mean
everything from declaring variables and objects to adding and deleting
records. For some reason this keeps confusing me. In fact, if anyone

Dear sir,
I AM A VB DEVELOPER 6.0, I AM USING DBASE(IV) DATABASE THROUGH DAO. I OPEN A
DATABASE BUT WHEN I OPEN DATABASE RECRODSET BY ORDER GIVE A RUN TIME
ERROR(3228)!!!

This may sound simple for some but the problem I have is with queries
that have up to 8 differnet tables, when someone designed the query
the failed to put in the full table name and field name.
The person I am now extracting data from this database for cannot read

Perhaps I am missing something here and maybe someone can show me my
mistake. In ADO, I can obfuscate the connection string for opening a
JET database with that uses User-Level security. If you use TextPad to
open the exe you will not see the username and password. In .NET,

 I hope someone knows this one.....
I have a disconnected recordset that is never attached to a real
datasource.  Fields are appended and records added in code.
I want to then delete some of the rows , I mean REALLY delete them so

i have  develop a  vb6 program , it run smooth in the  windows 98, 2000
but when it run in xp
it show this error :
"Run-time error '3709'  The Connection cannot be used to perform the