I'm getting the attached error messages when trying to modify records in a file. It's appears as though there is some protection in place, privilege sets etc, but there isn't and never has been. I've tried recovering the file to no avail, is there anything else I can try? I haven't accessed this file in approx. 6 months, but have never had issues before and I'm the only user of the file.

Careful with recovery, it's not a maintenance tool.  Only do recovery on a copy of the file, not the file itself.

The first dialog is a field validation setting, not a security setting.  If you know what field it is, go into Define Database and check the field's options and change it.

Thanks for the reply Wim, I'm at a loss with this. I've attached the file, wonder if you would be kind enough to go to the Rules Assessment QA layout and try to modify a record.

Rules_Assessment_-_031216.fp7

The field Assessors Comments has a validate by calculation on it - Get(UserName) = "fairburna" or Get(UserName) = "fusseyn" or Get(UserName) = "clare"

If you're not one of them, you get the message above.

Great stuff webko, removing the validation seems to have done the trick.

Strangely though, I am 'fairburna' on my work PC and another thing, I only had that validation on Assessors Comments so how would it affect other fields in the same table?

 

If you log in to the the database without credentials, then you are not as far as the database is concerned....

And it affects that field, and the record - as that field is set to validate, if it fails then no change will be made to the record.

Removing validation did the trick, but from your reply it appears that the source issue is logging in without credentials. I don't quite know how though because the only credentials are Admin with no password, and the file is set to open with the Admin account. I don't understand what has changed and why.

It can't be picking up on my 'fairburna' Windows username for some reason.

 

the Get(UserName) function in FM picks up on what the user name is as set in the FM preferences, not the account name that is used to log into the file.  To use the account name, use Get(AcountName).

Unless you log into the FM file with a windows account through External Authentication, FM has no way of picking up on what your windows account is.  You could of course force it to by taking a long way to it by creating a Windows OS logon script that writes your windows logon name to the FM preferences in the registry so that the FM Get(UserName) can read it...