VB Forum / Database Access / January 2004

I tried to execute the following code
Private oCon As New ADODB.Connection
   oCon.Open "Provider= SQLOLEDB;Integrated Security=SSPI;Persist Security
Info=False; Initial Catalog=ARCO;Data Source=AlexZ"

Hi all.. I have a problem with inserting a date field from VB into MySQL.
The entered value in MYSQL shows 0000-00-00
This is what I have in VB
Dim SDateFormat As String

I'm having some difficulty searching a set of rows in a DataRow collection..
This is my question
What would be an efficient way to search any column of an DataRow array
Let me try to explain the context of this question, that will help you understand what I'm looking for..

I am looking to design a visual basic program which stores information of
rooms and allows people to reserve them for a certain date and time.
Sounds simple enough but I don't really know if visual basic is the right
way to go about this as I have never used the calendar control in ...

With a Ado database connection with ADODC.ocx and I want to delete all
records .I have tryed :
       Base.recordset.delete AdAffectAll
Bit I have a 3219 error , so I search on Google in newsgroup to found help,

I want to use a password protected access 2000 database.  
I first tried to access the database without a password
and that works OK:
 SourceName = dbLoginPath & "\generallogin.mdb"

I have searched google for this error message and found a lot of people 2000/2002 were asking
about it.  Generally it appears sporadically, just often enough to make users consider your
software broken.  It occurs when you issue a recordset update in vb or asp.  The database can ...

I am trying to remove indexes from an Access table using ADOX, and I get the error refered in this KB article
http://support.microsoft.com/default.aspx?scid=http://support.microsoft.com:80/s
upport/kb/articles/q201/8/26.asp&NoWebContent=
I checked causes refered to in this article ...

We have created the procedure in VB with the following
code. But the

I have an application which has been created using visual
basic(vb 6) and uses Microsoft Access Database. Till last
week it was working fine. But now it is taking lot of time
to execute queries. I have also checked that it is not

Anyone know if this combination will work?
Thanks

Here is my question. I have two tables in my database and
I need to get the data from one table and do some work on
it. Before I do any work, I need to check if the record
lies in the second table (basically check one particular

All,
I am going CRAZY with this issue!!!! I am trying to find out how I can edit a new record.  First I create a new record using the .addnew method.
I then save the record with the .updatebatch statement.
When I do this I donot get back the new id value. AND when I try to edit and ...

Hi there guys, it's me again, first of all let me tell you thanks for all
the help you have given me in the past this newsgroup has been so helpful!
But once again I have a problem...it's really hard when you're trying to
teach yourself how to program!!

I am running a vb6 application which accesses an SQL server database and
an Access database.  I have a table in the access db which is populated
every time i run the vb app.  However, when i run the application and
run an access query which just changes the order of the above table ...