Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post

    Database On Peer To Peer Computer (Access 2002 SPI)

    Hi guys.... I'm having trouble accessing a database on a machine on my peer to peer network. Access says I have to move it to my local machine in order to access it. It didn't use to be this way.... I have searched the forum, but I didn't find anything I understood.

    So, I have a database that lives on a fileserver, and I need to access it from any peer to peer machine on the network. Can someone tell me how to overcome this new 'security' issue in terms I can understand?

    My Access 97 databases are working fine in this configuration.

    Thank in advance!
    KST

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

    Re: Database On Peer To Peer Computer (Access 2002 SPI)

    Try splitting the database into a shared backend and individual frontends. See Why Split a Database? by WendellB.

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Database On Peer To Peer Computer (Access 2002 SPI)

    Hey Hans... Thanks for the info. I have actually tried that, and I still get the security error message. Using the database utility, it actually starts a _be.mdb file, but then the security error comes up again. The back end file is about 66 kb, and had no info in it. Of course, I could not access it because Access thinks it's in an 'Untrusted' zone.

    So, I'm still confused as to why Access thinks the peer to peer computer is not secure, or in an 'Untrusted' zone.

    Thanks again Hans!
    KST

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

    Re: Database On Peer To Peer Computer (Access 2002 SPI)

    Try adding the computer (computername) containing the backend database to your Trusted Sites in the Security tab of Tools | Internet Options in Internet Explorer.

  5. #5
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post

    Re: Database On Peer To Peer Computer (Access 2002 SPI)

    BAM! That was it! That's what's holding me up w/ Access 2002, not only here, but in some other places as well. I'm sure I am not the only amateur with this issue.

    Love this forum!

    Thanks Hans!
    Have a great week!
    KST

Posting Permissions

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