Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Read Only (Access 2003)

    How do I "turn off" Read Only.

    I have a database that contains one table. This table is employee data. I have three "application" databases that are linked
    to this employee data. Two of those are also linked to the "data" database for thier individual application. Last week all was well.
    All of the sudden, when I try to refresh the employee data, I am getting errors "Can Not Delete From This Table" When I try to oprn the
    database, I get the message that the Database is Read Only.

    Is there a way to go into the database and turn this off?


    Thanks
    Richard

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

    Re: Read Only (Access 2003)

    Have you checked whether the .mdb file has been set to read-only? (Right-click the .mdb file in Windows Explorer and select Properties from the popup menu)
    Are you sure that you (and everyone else using the database) still have modify permissions in the folder containing the database?

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read Only (Access 2003)

    The Explorer properties are not set to Read-Only. I double checked to make sure.
    I know there is at least one person that can make updates. I know there is at least one
    outher person that can not.

    Is there a switch I should be setting in the shortcut they are using.
    I have copied the Application side of the db local for each user.
    The Data is on a shared network drive.


    Thanks for your help
    Richard

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

    Re: Read Only (Access 2003)

    If some users can update without a problem and others can't, I would suspect that those who have problems don't have sufficient permissions on the folder containing either of the databases. Access requires all users to have modify permissions (read/write/create/delete) to the folder containing a database (these are permissions at the Windows level, they have nothing to do with Access security).

  5. #5
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    USA
    Posts
    386
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Read Only (Access 2003)

    That looks like it. I tried to copy a file to the directory and it fialed.
    Weird, I placed the dbs in the folder and had no issues.

    Thanks, guess my next stop is network services.
    Richard

Posting Permissions

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