Cannot access forms, macros, modules

[Guest]

I may have locked myself out of my database. I'm hoping someone has work
around.

I turned off special keys and I set allowbypasskey to off. Its been a
while, but I believe I also set the DDL option to true, meaning you cannot
allow the bypass key withtout admin permissions.

I thought I left myself a back door with a special key combination to set
allowbypasskey to true. But, thats not working.

I can run the database, enter and change data, etc. I can link and copy the
tables and queries, but not the forms (vba behind), an autoexec macro, and a
module. I can not bring up the database window.

I've tried using Ron Weiner's excellent utility at:

http://www.worksrite.com/AllowBypassKey.htm

to try to set the allowbypasskey to once again allow access. However I get
the error message:

Error - 3303
Descr - You do not have the necessary permissions to use the 'MSysDb'
object. Have your system administrator or the person that created the object
establish the appropriate permissions for you.

The database does not have user level security nor a database password.

On the default security file I've made sure that the default Admin has
Admins permissions.

I don't know what Access is looking for. I'm at a loss. Thanks for any help.

Regards,
Leif

 

[Douglas J. Steele]

Try creating a new database and importing the forms, macros and modules from
the existing database.

 

[TC]

You say that the database does not have security, but you've clearly
been fiddling with at least one workgroup file ...

Try this. Use the workgroup administrator program or function to
(re)join the standard system workgroup file (system.mdw, usually in
c:\windows or similar). Check the Admin user is a member of the Admins
group of that workgroup file, and does not have a user password. Then
try the unlocking utility again. If is still doesn't work, try again
with any other .mdw files on your PC. When you've finished (or given
up), remember to re-join whichever workgroup file you wiush to continue
with.

HTH,
TC

 

[TC]

Or try Douglas's simpler solution!

TC

 

[Guest]

I tried that. I was able to import the tables and queries. I was not able
to import the forms, macro, and modules. My VB is password protected, I know
the password, but it does not give me the opportunity to input it.

 

[Guest]

I've tried that (join system.mdw and checking on the Admin user). Admin does
have the Admins permission with no password, so it didn't help.

 

[TC]

A quick google groups search on:

"vba password" import

suggests that you can not import the modules if it has a VBA password.

HTH,
TC

 

[Guest]

Yep, that’s my dilemma. I know the password, but that does me no good. I
cannot use Alt-F11 to bring up the module and enter the password. Likewise,
I cannot link to the module since it has a password.