If you have a user, such as admin with no password and full access
Open the File Options under File Menu and click [Log in using:]
Specify the Account and Password (blank in this case)
If you are creating a new database from the file menu in Filemaker, the settings davidanders describes should be the default settings for your file. If you are saving a copy of an existing file or using the operating system to make a copy of an existing file, any settings it has will be copied with the file.
Thanks folks, I already tried that. But everytime I reopen that database, the login dialog appears, even though it's filled with the account name. I went to the File Options after opening the database and set it to login using Guest but it still shows the dialog when reopening. That's the part it was not showing before and I"m not sure what has changed.
Do not select "guest account"
Select the "log in Using" check box and the "account name and password" radio button. Enter admin for account name. Leave password blank.
I just did what you suggested, File Options -> Log in using admin, password blank. Clicked OK. Closed the database. Reopened the database. The Open Database dialog still appears. It has the account name filled so I can just hit Return but I'm still confused about why this dialog is still appearing. I have been using this database for over a year now and I set it to login automatically initially and I never seen the "Open Database" dialog having to log in. I'm stumped!
Does the file link to any other FileMaker files? A reference to such a file can cause it to open and it might pop up your password dialog.
Have you checked your file for corruption? Run a recover on it and see what is reported.
There have been a few reports recently of files spontaneously changing behavior and popping up a the log in dialog when they shouldn't, but I haven't been able to spot any consistent pattern nor has anyone from FileMaker Inc. confirmed this from their database of trouble reports...
Thanks. No it is not linked to any other FileMaker file.
I did delete all preference files relating to FileMaker Pro. Now, it's even worst. Even though I opened the database and set the File Options again to log in using "admin" with a blank password, now everytime I reopen the database, it shows the Open Database dialog but with my Mac OS X user account name filled in!
I'm going to run the recover utility and will report back as it seems there is something wrong with it.
If you want, you can uplosd a copy of you file to a share site and post the download link here. Then others can take a look at it.
Thanks Phil. Here is what I did: I restarted my Mac. Now, everything is fine and I can open the database without having to authenticate. Weird! The new Mac OS seems to be looking more and more like the old Mac OS. A problem? Restart is the answer... not!
Thanks for your help!