Locked out??

[Günter Brandstätter]

Hi all,
I have a severe problem with a database I wrote originally in access 2000.
My first steps in Access 2003 were to convert this database to 2003 and to
lock up my VBA-project. Now it wont let me in again to make changes to the
code I wrote.
Made another mistake to delete original .mdb which was written in Access
2000.

Any help appreciated
Günter

 

[Brendan Reynolds]

What does 'lock up my VBA-project' mean? What exactly have you done?

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Günter Brandstätter]

Hi Brendan,

thank you for your response. If I knew what I've done, I could tell you
more. I tried to secure the VBA code with a password, but now, when I try to
open a form's code, I get the message "This project is locked". It does not
even request my password, there is just one button <OK> on this message-box.
That's all I know.
If you have any clue, please let me know.

Günter

 

[Brendan Reynolds]

I checked, and if I password protect the VBA project in Access 2003, close
the MDB, then open it again and try to view the code behind a form, I'm
prompted for the password. So I suspect that you may have done something
else in addition to just setting the password, but I'm not sure what. You
haven't converted the MDB to an MDE have you?

Assuming that you haven't converted the MDB to an MDE, you could try opening
the MDB, then pressing Ctrl+G to get to the Immediate Window in the VBA
editor without opening any code module. Now choose <YourProjectName>
Properties from the Tools menu, select the Protection tab and clear the
'Lock Project for View' check box and the 'Password' and 'Confirm Password'
text boxes.

--
Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

 

[Günter Brandstätter]

Hi Brendan,
sorry to have disturbed you, but you are right, I changed the MDB to MDE,
without knowing. The file-extension was still MDB, but when I tried to set
up user-security on this file, the program told me that it was not possible
to do this on an MDE file.
I don't know why the extension rested MDB.

thank you again
Günter