server oddity

[gephry]

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?

[Vaughan]

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.

[Steven H. Blackwell]

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

Steven

[gephry]

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!