Results 1 to 6 of 6
  1. #1
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Leigh on Sea, Essex, England
    Posts
    263
    Thanks
    0
    Thanked 0 Times in 0 Posts

    warning messages when opening (2003)

    Hi,

    Ive finally realised that my Excel workbook is just too unwieldy now, so I've taken the plunge and have begun creating it as an Access database - something that I've never used in anger before. What surprises me given that it currently only has four tables and I created it, is that Access gives me a warning each time I try and open it to check if I really want to do this. It's extremely irritating - how do I turn it off.

    Thanks.

    Stuart

  2. #2
    5 Star Lounger
    Join Date
    Apr 2003
    Location
    Hampshire, United Kingdom
    Posts
    602
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: warning messages when opening (2003)

    With Access 2003, Microsoft introduced Macro security settings, similar to the Macro security settings in Excel/Word/etc. You can disable the messages in the same way, ie.:
    <UL><LI>Open Access<LI>From the Tools menu, click "Macros..."<LI>Click "Security..."<LI>Change it to "Low" and OK your way out of the dialogue boxes[/list].
    Waggers
    If at first you do succeed, you&#39;ve probably missed something.

  3. #3
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: warning messages when opening (2003)

    You can also sign the VBA project in the database with a digital signature. See How to add a digital signature to a custom macro project in Office 2003 and Office 2002.

  4. #4
    3 Star Lounger
    Join Date
    Feb 2001
    Location
    Leigh on Sea, Essex, England
    Posts
    263
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: warning messages when opening (2003)

    OK. I understand that and can do that. But I'm still confused as my project doesn't HAVE any macros! In Excel, if there are no macros then you get no warning - you only get the warning if there are or were macros. Is this a particular "feature" of Access?

    Cheers,

    Stuart

  5. #5
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: warning messages when opening (2003)

    The whole concept of macro security is new in Access 2003. I assume that an Access database already contains the components needed for VBA code when the database is created, whereas those components are only added to a Word document or Excel workbook when you actually create some code or a userform.

  6. #6
    5 Star Lounger bfxtrfcmgr's Avatar
    Join Date
    Aug 2002
    Location
    Fresno, California, USA
    Posts
    995
    Thanks
    12
    Thanked 0 Times in 0 Posts

    Re: warning messages when opening (2003)

    Waggers:

    Thanks for your post! I discovered that my new install of 2003 did not have the "security" option in the Tools | Macros menu; I had to add it my self. I have attached an image of the help file for those who may need to add it to the menu.
    Bryan,
    Not the smartest critter on the glacier. . .
    . . .but I'm persistent (does that count?)

Posting Permissions

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