Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2006

    Unanswered: Macro/VB Security Level in Access 2000

    I created a database using Access 2003 in Access 2000 format and have thoroughly tested it and it works on my machine. I recently transfered the database to a user with Access 2000, and it will not run any of the VB code that I have written, which basically makes the database useless.

    I have tried setting the security level to medium in the other office applications, but this didn't help, and have also added the following keys to the registry, and it's still not working:

    HKEY_Local_Machine\Software\Microsoft\Office\10.0\ Access\Security\Level=2
    HKEY_Current_User\Software\Microsoft\Office\10.0\A ccess\Security\Level=2

    Does anyone else have any suggestions?

  2. #2
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Have you checked for missing references? Make sure Visual Basic for Applications is checked.
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts