What is Wrong with this Picture? 
Author Message
 What is Wrong with this Picture?

This routine creates a new DB and tables using a new ADOX catalog
object. Creating a DB at runtime in DAO was a breeze, seems a bit
Quirky with  ADO 2.1 DDL.

set catdb = New ADOX.Catalog

catdb.Create "Provider=Microsoft.Jet.OLEDB.4.0;" & _
      "Data Source=" & mvarDB & ";" & _
      "Jet OLEDB:Engine Type=4;"  <--------Which type to use??
                                      4=MDB Ver 3.0, 5=MDB 4.0

This table is created just fine, But I cannot update it! I delete
the lines that add Date Columns, and it becomes Updateable.
Something is wrong with the way I am creating a adDate column.
Any Insight would be great!

    Set tbl = New ADOX.Table

    With tbl
        .Name = "Messages"
        Set .ParentCatalog = catdb
        .Columns.Append "MSGNUM", adInteger
        .Columns("MSGNUM").Properties("AutoIncrement") = True
        .Columns.Append "TO", adVarWChar, 10
        .Columns.Append "USERID", adVarWChar, 10
        .Columns.Append "ADDDATE", adDate   <--------Problem Code
        .Columns.Append "CMTDATE", adDate   <--------Problem Code
        .Columns.Append "EMPNAME", adVarWChar, 48
        .Columns("EMPNAME").Attributes = adColNullable
        .Columns.Append "GROUPNAME", adVarWChar, 64

        catdb.tables.append tbl

Sent via Deja.com http://www.***.com/
Before you buy.

Sat, 13 Apr 2002 03:00:00 GMT
 [ 1 post ] 

 Relevant Pages 

1. Simple one what am i doing wrong

2. newbie - Am I barking up the wrong tree?

3. What am I doing wrong?

4. What in the world am I doing wrong?

5. TSQL question - what am I doing wrong?

6. Bug in SQL or am I wrong?

7. I think I am doing something wrong

8. What am I doing wrong here?

9. Where am I wrong with the delete statement?

10. What am I forgetting or doing wrong

11. Am I doing something wrong...??

12. what am I doing wrong in this procedure?

Powered by phpBB® Forum Software