I have a file that works perfectly locally. As soon as I get it on the server (FS8) one script stops working. The problem:

The entire script works fine except for the create a "new record" step. It performs all steps and goes to TABLE2 but then it won't create a new record! If I run it locally, no problems whatsoever. Computing, new records, etc---no problem locally. So I have no clue why the heck it's doing this on the server.

I thought maybe a privilege set problem, but I doubt it...

ALL of my privilege sets include this:

Access via FileMaker Network (fmapp)

Records: Create and Edit in ALL tables.

All other databases work perfectly fine. Just this one "new record" command in this database.

Any ideas?

You need to get the error code so you can work out exactly what the problem is. Best method is to change the script to thus:

Set Error Capture [on]

New Record/Request

Set Variable [$error ; Get( LastError )]

Show Custom Dialog [ ... ]

... where the custom dialog's message is the $error variable. Write it down then look it up in the FileMaker Help topics under the Get( LastError ) function article.

Check the OS level permissions for the file. Do you get any sort of warning when you open the file?

Steven

Vaughan --- excellent idea.

Error #6 is what came up. So file is read only. Odd. Whenever I logged in through the server on a client account....read only and wouldn't allow you to create records Makes sense. That might have happened when I recovered the file....it probably set all other users (except for my [Full Access] account) to read only.

Thanks!