VB Forum / Database Access / June 2005

I need to update all the default values of the fields in Access.
I don't know what fields have default value.  So, I open all the tables and
look throught all the fields.
Would you guys point me to a better way to do this please?

The error I'm getting is :  Multiple-Step operation generated errors. Check
each Status value.
Throughout this whole process I get the same error everytime I tryto update
the record set.

I am trying to open an Access 2000 database.  The book I am reading says to
go into the Components dialog box and select the Microsoft Active Data
Control 6.0.  I go into the components dialog box but the Microsoft Active
Data Control 6.0 is not there.  I do find an entry for ...

I have an Access DB and one of the columns is set to a Currency type.
I get the records into a variant array via...
If myConnection.State = adStateOpen Then
           myRecordset.Open "SELECT * FROM " & sTable, myConnection,

I get the following error message when i try to open a ADODB Connection from
a Visual Basic 6 application.
 Error: "String data, right truncation"
Actually, this application works with no problem at all of the customers

I am trying to create a simple utility in VB that sits and watches for a text
file in a specific location, once it sees that file (I can handle up to here)
It needs to import the text file and write it to a SQL table.
Sort of lost on where to start.  

I am now working in Access 2002 and am trying to define a recordset in my
current database.  In Acc 2000 I used to be able to define an object as type
"database", but Access 2002 does not recognize the type.  Do I have something
turned off or is there a new way to open a ...

   I'm using VB6 and Access 2002. I've been unsuccessful in creatinf a new
Access database from code. Can someone point the way for me?
Thanks alot in advance.
J

Is there something more elegant than the following line to check (in vba)
whether and object is set?
Dim frm as form
If Not frm Is Nothing Then

   I'm using VB6 and Access 2002. I've been unsuccessful in creatinf a new
Access database from code. Can someone point the way for me?
Thanks alot in advance.
J

In my VB6 application (use ADO 2.8), I get the error "-2147217887 :
The Microsoft Jet database engine stopped the process because you and
another user are attempting to change the same data at the same time" in
rs.Update when trying to update a value of an Access query.

I have an 'Append Query in Access which just inserts into all 4 fields
(simple insert)
I have created a OLEDBConnection and a OLEDBCommand.
The OLEDBConnection connects fine to the db

   I use VB6 and Access 2002. How do I use the SQL alter table statement
to:
       create a one-to-many relationship,
       enforce referential integrity,

I have a hierarchical, static, disconnected  ADO recordset.
I attempt to update one of the fields in it:
--------------------------------------------------------------
   with oRS

The following query returns the all designs with the word Christmas in it
when executed in Access but returns no records when executed in VB 6.0
Select * from PI where DesignName Like '*Christmas*'
Could someone help point me in the right direction please.