I'm not sure how else to describe it other than, "it's REALLY strange!"

I am running our former FM8.5 and FM7 databases just fine on our new FMServer10 software. I just completed a new Filemaker 10 database and am now sharing it through the server---but I'm having a lot of issues with this file and this file only.

The FM10 file is designed that it opens under a default limited user account (specified in File > File Options)...but it won't open under that account. It prompts for a username and password! So I added an "On Open" script that does an automatic Re-Login without dialog...and it won't do that either! It still prompts for a username/password and then tells me that I don't have enough access privileges to perform that action.

Strange!

I have the file permissions set to "Read & Write" for every and all users. I've done file recovery and no issues were found. So I'm stumped!

The thing is when running this on Filemaker 10 or Filemaker 10 Advanced it works perfectly fine!

Any suggestions? Thanks!

Disclaimer: I only posted because after searching long and hard, I couldn't find an answer already posted in the forums. BUT! I continued my search and finally found what I was looking for.

(Administrators if you feel like deleting this post, great; if not, here's the solution for anyone else that's having the same problem.)

I found it in this post:

http://www.fmforums.com/forum/showtopic.php?tid/190005/

It is simple simple oversight on my behalf and of course: it's a single checkbox. When making new Access Privilege Sets for users make sure you check the "Access via Filemaker Nework (fmapp)" checkbox in Extended Privileges in the Accounts > Privilege settings. Otherwise Filemaker won't allow that Privilegeset to access the Filemaker database(s) through the server.

This is why it wasn't auto-logging in, and why it was giving me an error when I was trying to do it through a script.

Just goes to show: if you need an answer, search harder.