ADOX, Access 2000 and Jet OLEDB property settings 
Author Message
 ADOX, Access 2000 and Jet OLEDB property settings

Here's my question, and I've looked everywhere, so hopefully someone can
help here...

Here's my code:


    Set mCat = New ADOX.Catalog
    Set mCon = New ADODB.Connection

    mCon.Open "Provider=Microsoft.Jet.OLEDB.4.0;" & _
             "Data Source=" & strDBPath & ";" & _
             "Jet OLEDB:Database Password=1234;"

    Set mCat.ActiveConnection = mCon
    Set TBL = mCat.Tables("Table")
    TBL.Columns("Item").Properties("Jet OLEDB:Compressed UNICODE Strings")
= -1 ' True
    Set TBL = Nothing


Here is the problem...I try running this code and I get an error of
"Multiple step OLE DB operation generated errors"  Anybody have an idea of
what I'm not doing right?  I'd also like to be able to change the Format of
a Date field to "short" in an Access database through VB code, but I haven't
found anything on that either...



Tue, 06 Jul 2004 08:50:25 GMT  
 [ 1 post ] 

 Relevant Pages 

1. How to set Format property in ACCESS2k thru ADOX using JET OLEDB 4.0 provider

2. ADOX: Jet Oledb 4.0: How to set Format property for a column

3. ADOX, Jet OLEDB 4 & Access 97 .mdb

4. Can't Access Users collection in ADOX (Jet OLEDB)

5. ADOX, Jet OLEDB:Allow Zero Length ERROR...

6. Setting Field Properties in Access 2000 possible?

7. ADOX and Jet DB field properties

8. Jet OleDB: Allow zero Length property returns True

9. Field properties bug in Jet.OLEDB provider SP5

10. Access 2000 and ADOX

11. Convert an Access 2000 MDB to ADOX creation code

12. Cannot view queries created using ADOX in Access 2000 interface


Powered by phpBB® Forum Software