VB Forum / Database Access / July 2006

Using the naming conventions as follows:
Server Name: srvServer
Database Name: dbDatabase
DTS package name: dtsPackage

Just installed Visual Basic 2005 Express Edition. Off to a
very fast start. When attempting to link to a data source which
is a ms access database I get the following error (if I wrote it
down properly).

   I got a big problem, inconsistent date format in access. I dun know why
when I do query in access wich parameter dd-mm-yyyy when it goes to database
it became mm-dd-yyyy.
   Okie let me explain more detail. I writing a vb6 program that will doing

My programme has connected to an Access database. I made a query on a
condition and want to replace ALL blank fields with "NULL".
My coding:
After processing on a query.....

This si from a VB6.0 application
DAO 3.51 and ACCESS 97
Please help review the code below and let me know what I need to do:. \
Always got err msg : Method not found on the line Set Data1.Recordset =

Provided that my programme is connected to an Access Database and I have a
text box for input (E.g. Street name), how can my input data be
automatically completed with just key in first few letters.
i.e. With "ABD", "ADFR", "BDNR" street names stored in the database, when I

The code below always seems to return -1 even when there are zero records
returned. I thought that you would get zero if the set was empty.  When I
check EOF I get true or false and have had to use EOF True to detect the case
where 0 records are returned.  What am I doing wrong?  ...

My Vb 6.0 application uses MS Access as database and it connected to VB
through ODBC Driver.I am having a union query (say [A]) in access and when i
call this union query from VB i am getting the error .
Run-time error '-2147217904 (80040e10)': [Microsoft][ODBC Microsoft Access

IDE: vs2005
Language: vb.net
Task: open a microsoft excel file, load it into a dataset, and bind it
to a datagridview control.

When I execute the code below the table is actually created successfully but
I get an error message.  It jumps to the error when I try to close the record
set saying that the object is already closed.  I thought that I should close
any record set that I opened.  Since this query ...

HOW EXTRACT A DATA FROM A DATABASE WHERE VALUE = VALUE OF TEXTBOX1.TEXT
FROM A ACCESS DATABASE IN VISUAL STUDIO.NET

Is there a diffrence in performance between these 2 databases, SQL & MySQL ?
If so then what are the diffrences if any? Also Is there a way to get MySQL
to work just excatly like SQL? Or is it just strictly for PHP?
Cheers!

im developing a desktop application that conect to a database, and that
database file is in the application development folder, and i made a dataset
that conect to it but after packaging and installing on client pc the
database path will change so haw can i handle this problem ? ...

What is the simplest way to check and see if the user's ADO Connection has
been lost (eg., the network cable is unplugged).  I've tried checking to see
if the connection object "Is Nothing" and tried checking the State property
(=adStateClosed), but neither works.