Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Oct 2004
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Problem Read-only/Object link files (Access 2000 (9.0.3821 SR-1))

    I am have a problem with the read-only table after opening one Object/Linked/file. Once one Object/Linked/file has been opened on a row, the keyboard and mouse lock up. The only thing that can be viewed without closing down the table/query is the same Object/Linked/file that was first opened. If the Access file is not in read-only it works properly. I need help as I have several persons with read-only status to these files.

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Problem Read-only/Object link files (Access 2000 (9.0.3821 SR-1))

    Are two people trying to open the same OLE file - in general that doesn't work as the files are single user and are locked once they are opened. In general we discourage the use of OLE objects, as they tend to bloat the database, and cause issues of the type you are experiencing. We recommend instead a hyperlink to the file location - that does of course mean you have to do some maintenance work to make sure files don't get moved or deleted by users.
    Wendell

Posting Permissions

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