3 Replies Latest reply on Jun 16, 2009 10:08 AM by philmodjunk

    I have one database where "read-only" access refuses logins -- any ideas?



      I have one database where "read-only" access refuses logins -- any ideas?

      Your post

      On my FM 10 Server (on the Mac), I have a database with 3 accounts on it:


      bfdbrw -- External Server -- [Full Access]

      admin -- FileMaker -- [Full Access]

       bfdbro -- External Server -- [Read-Only Access] 



      bfdbrw and bfdbrw are groups on my server that contain server accounts.


      Members of bfdbrw -- can log into the database


      members of bfdbrwo -- can *not* -- they get a message that:


      "The account and password you entered cannot be used to access this file.  Please try again."



      HOWEVER -- if I change bfdbro to [Full Access] -- then those users can log into the database.


      I added another local account just as a test (one not authenticating against my server) -- if I set that to [Full Access] -- I can log in.   Change it to [Read-Only] -- I can't 



      I didn't create this database, but the permissions on the database on the server are the same as all the other databases:



      -rw-rw-r--   1 fmserver  fmsadmin   10407936 Jun 10 23:00 <working.fp7>

      -rw-rw-r--   1 fmserver  fmsadmin     458752 Jun 11 12:31 <bad database.fp7>

      -rw-rw-r--   1 fmserver  fmsadmin   22757376 Jun 10 23:00 <also working.fp7>



      Is there any setting *within* the database that could be made to say that 'read-only' users can't actually log into a database that I'd need to toggle?