Help with code in FAQ181-1172

[famehrie]

I was using the code provided in FAQ181-1172 and it stops on the following line:

Set prp = dbs.CreateProperty(strPropName, varPropType, varPropValue)

I receive the following error:

Run-Time error '13':
Type mismatch.

I'm no programmer and I am just learning what ever I can about access. Can Anyone let me know what may be wrong with the statement above.
I am using Access 2000.

Thanks

 

[cmmrfrds]

There are 2 data object libraries in Access ADO and DAO. In Access 2000 the default library is ADO and the code you are referencing is DAO code. Set a reference to the DAO object library in your program and then explicitly define your data objects with the DAO prefix. To set a reference go to the Menu under tools while you are in some vba code. Pick references and look for the DAO reference in the list.

DAO.Properties etc.....