Data type conversion error when doing DisableByPassKeyProperty()

[DaOtH]

Hello all...

In this forum i found a posting about disabling the Shift key. I am trying to get this into my database but get a nice error which i can't work around. It might be simple but i don't know.

I am trying to run the following :
Sub DisableByPassKeyProperty()
Dim prp
Set db = CurrentDb
Set prp = db.CreateProperty("AllowByPassKey", dbBoolean, True)
db.Properties.Append prp
End Sub

When running this it gives me an Data Type conversion Error (3421).

Anybody any idea what i am doing wrong here ?

(Using 2000) "In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963

 

[Ed2020]

What line does the error occur on?

Ed Metcalfe.

 

[DaOtH]

it was on the prp= line, but i found whats wrong already...

i tried Dim prp as property already as well but it was nessescary to put Dim prp as DAO.property. "In three words I can sum up everything I've learned about life: it goes on."
- Robert Frost 1874-1963