Have you tried admin with a blank password?
Thanks for the rapid response Chamblee... I confess, I am not quite sure what you mean by Admin - the Mac admin or is there some FMP12 admin I should be able to access? Your suggestion prompted me to check the I/O status of the document, which indeed was read only, so I unlocked that using the Mac Admin but it still prompts me to use the admin password when I try to open it, which it ignores :-(
Passwords in FileMaker are now two part passwords, and account name and a password. If no password has been defined by the user, the default account name and password is an account name of "admin" and nothing entered for a password. If, in File options, the option to auto enter "admin" with no password has been cleared, then you will get a password dialog, but you can get past it by entering admin for the account name and leaving the password box empty.
Then you can go to File options to fix this setting so that you are not asked for a password in the future.
Thanks Phil - assuming I read this corrrectly, I am having no joy:
When I try to open the file, I get asked for my root password for my Mac, which doesn't work. So I tried your workaround, which was to enter "admin" under account name and leave the password blank - de nada! You mention File option - I don't have any options in the dropdown under file (probably misreading the suggestion). I am beginning to suspect that there is something wrong on my Mac rather than FileMaker here. I have noticed that since buying this, there have been some odd behaviours around permission settings. For instance my trash asks me if I want to trash and then erases what I put in it when i drag it over, which is odd. Also, many files seem to be read only. Maybe nothing - but it may also be my problem... I will dig deeper...
Okay guys - my worst fears are confirmed - I check the read/write; they are clean. There are 7 tables for this database (I can convert 5 of them no problem), two of which used to be password protected about 15 years ago. I removed that password protection in FMP7 because I was getting issues with it - but FMP12 (cleverly or annoyingly) is asking me for a my admin password for these 2 tables only, which I supply and it ignores. Something has gone astray in FMPro over passwords and I can't seem to unlock it. Does anyone know of a sustainable way around these legacy password issues, because I vaguely recall it was a problem in FMP7 but I managed to find a temporary fix?
File Options will not be available until you can successfully open the file.
Can you open your unconverted files with an older version of FileMaker?
I don't know what you mean for sure when you say: "When I try to open the file, I get asked for my root password for my Mac,"
FileMaker cannot and will not ask you for any such password. I would guess that you see your current user name entered as the account name in the password dialog. This is a standard default setting, but it is NOT asking you for the root password for your mac.
Is there any chance that you had Keychain set up to automatically open your file with a password? That would explain why you are now asked for a password with the new version when you weren't with the unconverted copy.
Phil - you cracked it. I have never used keychains before because i don't trust my own memory to pick up passwords if the keychain ever failed. That could be an anachronistic view but it is a discipline I try to maintain. Having said that, I have just opened access to my keychains for the first time ever and saw a whole slew of them, and nesting in there was the database in question! I found the username and password, applied it and it works! resurrected at last; many thanks Phil. I am now free to commit all sorts of crimes against good sense on FMPro!