Results 1 to 4 of 4

Thread: Read Only Error

  1. #1
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post
    Hello, we have a new server running Server 2003. We have a 'Front End' and 'Back End' database. When we open the database from a workstation on the new server or from the the new server, we are in 'Read Only' mode. However, if open the database through the old server, it works fine. All permisions on the new server match the old server.

    Can someone give us some ideas on things to check? Running Access 2000 / 2003. Backend is 2000 - most workstations are 2003.

    Thanks in advance!
    KST

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts
    Make sure that the user has full permissions (read/write/create/delete) on both the folder containing the frontend and on the folder containing the backend.
    Also make sure that the frontend file is not read-only (you can check this in Windows Explorer).

  3. #3
    2 Star Lounger
    Join Date
    Feb 2003
    Location
    Carrollton, Georgia, USA
    Posts
    123
    Thanks
    3
    Thanked 1 Time in 1 Post
    [quote name='HansV' post='793736' date='17-Sep-2009 11:32']Make sure that the user has full permissions (read/write/create/delete) on both the folder containing the frontend and on the folder containing the backend.
    Also make sure that the frontend file is not read-only (you can check this in Windows Explorer).[/quote]


    Hey Hans, we've checked that already. When I created the active directory of users and groups all the settings are the same as old server, but I have been reading up and windows is saying that even though folders permissions are set right that the ACL or ACE in server 2003 default permissions on new groups could be overriding the folder permissions. Im still looking into it. Thanks for your help. Let me know if you have any more thoughts on this!

    KST

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts
    You might also try moving the front-end to a folder on the workstation, and see if that still leaves you in Read-Only mode - I suspect it still may - we usually can get WinServer 2003 to behave by setting the folder permissions, but WinServer 2008 is a bit more picky and requires a fair bit of tweaking to get Access databases to be updateable. FYI, we normally use SQL Server as the backend as we get more control over security, and avoid issues like you are encountering.
    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
  •