Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Open File - Security Warning (access 97 sr2 win xp pro sp2)

    Not having restarted the workstation for a few days I have so far not seen this problem.
    But - restarte this morning and since then whenever I try to open access database I am seeing:
    Open File - Security Warning
    Dialogue box text:
    Do you want to open this file?
    Name: xyz.mdb
    Publisher: Unknown Publisher
    Type: Microsoft Access Database
    From: S:et cetera

    No certs on system.
    Any suggestions?

    Cheers
    Alan

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

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    Does this occur only for one database (xyz.mdb) or for all databases you try to open?

  3. #3
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    On all databases, but not on any other applications.

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

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    Does <post:=582,484>post 582,484</post:> help?

  5. #5
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    'fraid not.
    I've checked security access on each of the files I am trying to access (six), each in different network locations.

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

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    I'm afraid I'm stumped then. I hope someone else will come up with a suggestion.

  7. #7
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    Thnaks for taking a look anyway Hans. I am looking now (in between firefighting) at it being a new IT applied security setting regime. Just wish they'd make it known to all - even though there's only one door between us.
    I'll post result when known.

  8. #8
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    Partial solution but no explanation as to why it has just begun happening:-
    the shortcuts currently direct to a mapped drive.
    When using the shortcut the security message appears
    In windows explorer, if you navigater through the mapped drive and double cick the file - the security message appears
    IF I do not use the mapped drive but instead navigate through directly to the networked position and double click the file - the security message does not appear.

    Having changed my shortcuts to use the unmapped address - the security message does not appear.

    A result, but no full explanation - sorry.

    Alan

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

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    Try the following, perhaps it will help (but I'm not sure)
    - In Internet Explorer, select Tools | Internet Options...
    - Activate the Security tab.
    - Click on Local Intranet.
    - Click Sites...
    - Make sure that the first and third check boxes are ticked.
    - Click OK.
    - Click Custom Level...
    - Make sure it is set to Medium-Low or Low.

  10. #10
    3 Star Lounger
    Join Date
    Apr 2001
    Location
    Warrington, Cheshire
    Posts
    355
    Thanks
    3
    Thanked 0 Times in 0 Posts

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    Thanks Hans, very interesting. The level was already at medium/low but I did find in the custom level there is setting under miscellaneous to "Access data sources across domains" - this was set to prompt.
    Change it to enable, restart machine and all seems fine now.

    Cheers
    Alan

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

    Re: Open File - Security Warning (access 97 sr2 win xp pro sp2)

    Great! It should be OK to set it to Enable for Local Intranet - it's set that way on my PC too.

Posting Permissions

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