Can't create and set a new custom database property 
Author Message
 Can't create and set a new custom database property

I have a VB6 routine to create a new database (Access97),
a new database custom property and to set a new value to this property.
When I run this code:

Private Sub Form_Load()
Dim wrkDefault As Workspace
Dim dbsnew As Database
Dim strName As String
Dim strValue As String
Dim prp As Property
' Get default Workspace
Set wrkDefault = DBEngine.Workspaces(0)
'Make sure there isn't already a file with the name of new database.
If Dir("C:\Temp\test.mdb") <> "" Then Kill "C:\Temp\test.mdb"
'Create a new database.
Set dbsnew = wrkDefault.CreateDatabase("C:\Temp\test.mdb", dbLangGeneral,
'Create new Database property
Set dbsnew = DBEngine(0).OpenDatabase("C:\Temp\test.mdb")
Set prp = dbsnew.CreateProperty("UserDefined", dbText, "InitialValue")
dbsnew.Properties.Append prp
Set dbsnew = Nothing
'Set property name variable
strName = "VersionNumber"
'Set property value variable
strValue = "1.0"
If SetCustomProperty(strName, dbText, strValue) <> True Then
    'Error occured trying to set property.
    MsgBox "Error occured trying to set property."
End If
MsgBox "Done"
Unload Me
End Sub

Public Function SetCustomProperty(strPropName As String, intPropType As
Integer, strPropValue As String) As Boolean
Dim dbs As Database, cnt As Container
Dim doc As Document, prp As Property
Const conPropertyNotFound = 3270     'Property not found error.
Set dbs = DBEngine(0).OpenDatabase("C:\Temp\test.mdb") 'Define Database
Set cnt = dbs.Containers!Databases   'Define Container object
Set doc = cnt.Documents!UserDefined     'Define Document object
On Error GoTo SetCustom_Err
'Set custom property name.If error here it means property doesn't exist
'and needs to be created and appended to Properties collection of Document
Set prp = doc.Properties(strPropName)
prp = strPropValue                    'Set custom property value
SetCustomProperty = True
    Exit Function
    If Err = conPropertyNotFound Then
       Set prp = doc.CreateProperty(strPropName, intPropType, strPropValue)
       doc.Properties.Append prp      'Append to collection
       Resume Next
       'Unknown Error
       SetCustomProperty = False
       Resume SetCustom_Bye
    End If
End Function

I' ve got  Run-time error '3265':
Item not found in this collection.
It happened on Set doc = cnt.Documents!UserDefined

Could you please advise me how to fix this problem?


Fri, 12 Apr 2002 03:00:00 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Can't create and set a new custom database property

2. Can't create and set a new database property

3. Can't create and set a new database property

4. Setting shape custom prop to page's property

5. ADO2.1/VB6 Create Table can't set field properties

6. Creating properties of custom properties?

7. 'Canned' data in VB program

8. Record Set Guru's - Can't Create Record Set error 429

9. Record Set Guru's - Can't Create Record Set error 429

10. How do I create a canned form?

11. Getting Page Custom Properties onto a new page

12. Set Custom Property Value through a VB Form


Powered by phpBB® Forum Software