Importing into protected database

[dave.b.mcc]

I have recently upgraded from Access 2000 to 2007. At the moment I am
continuing to use the database in Access 2000 format since the
database has confidential information and I needed to retain the
ability to control access to the different parts of the database.

This morning I stupidly deleted a form from the database. No problem I
thought, I can import it from last night's backup. When I attempted
this I got error message : "Microsoft helps protect this Visual Basic
for Applications Project with a password. You must supply the password
in the Visual Basic Editor before you can perform this operation."

So I went in the VB editor and entered the password and tried again,
with the same result. I tried copying and pasting between the two
databases - still no joy. Finally I tried using the
DoCmd.TransferDatabase method, where I got a runtime error "2017" with
the same message.

This is really annoying, does anyone know a way to get round this?

 

[dave.b.mcc]

I found a work around, so the urgency is gone, but if anyone can
explain what is going on I would still be interested to know.

The work around:

I created a new form in the database, and copied and pasted all the
controls from the form in the backup database, then copied and pasted
all the code for the form. All I had to do then was a little bit of
tweaking the properties of the form and the controls and I was up and
running again.

Dave Bradshaw

 

[Brendan Reynolds]

I have recently upgraded from Access 2000 to 2007. At the moment I am
continuing to use the database in Access 2000 format since the
database has confidential information and I needed to retain the
ability to control access to the different parts of the database.

This morning I stupidly deleted a form from the database. No problem I
thought, I can import it from last night's backup. When I attempted
this I got error message : "Microsoft helps protect this Visual Basic
for Applications Project with a password. You must supply the password
in the Visual Basic Editor before you can perform this operation."

So I went in the VB editor and entered the password and tried again,
with the same result. I tried copying and pasting between the two
databases - still no joy. Finally I tried using the
DoCmd.TransferDatabase method, where I got a runtime error "2017" with
the same message.

This is really annoying, does anyone know a way to get round this?

It's been a while, but if I remember correctly, I think I had to open both
copies of the database and enter the password in both.