Very odd problem here: We have set up a database (for a non-profit) on computer "A", running OX 10.4 using FM 8.5 Adv.
NO other computer can edit any of the entries in ANY database created on computer "A", even though NO PASSWORD is set up.
All databases we've tried setting up have:
Account name [Admin] default
password (blank) default
Full Access
Account name [Guest] default
password (blank) default
On some databases we've built to test this, Guest has Read Access only (default); on some others, I allowed Full Access on the Guest account.
A trial was set up by creating a database with only two fields. No changes were made to accounts or privileges. Like all other files created on this machine, it cannot be modified when copied to ANY other machine running FileMaker Pro 8.5. No modifications can be made to existing records and no new records can be added to the database.
Any database created on computer "A" apperars to have Read Only access once it's moved/copied to another machine. If you look at the account name on the 2nd computer, it is Admin which was defined as Full Access when created on the original computer, "A".
To try to find a solution, I then created an account named [Debra] with a password of “useit”. It was given Full Access. On the second machine, FileMaker was restarted using the Option key to open the file. Debra was entered for the Account name and the password "useit" was entered. When the database opened, the privileges were Read Only. Admin (which still has Full Access as the default) has only Read Only Access when running on this 2nd computer. When running on the computer it was created on, "A", Full Access is available on both accounts.
If a database is created on the second computer, that file has full access when transported to my machine, "A".
NO other database this computer creates will allow any other computer we've tried (that has FM 8.5) to edit any data at all, not just from this database, but from any fake test one, either.
The worst part is that the computer this will be used on has the same trouble using it, and it's a PC, not a Mac. She needs full access and we're just trying to give that.
Can anyone help!?