I have a database file that I'm saving as two separate files, one with some sample data and another with zero records (when opened, script find no records and goes to config routine). I am trying to import records from the copy with data into the copy without, but get an error "Your access privileges do not allow you to perform this action". I am logging in to my source file as FMP admin (Full Access), I've tried doing the import from the Table view (can navigate to file but it's grayed out), from a script set to run with full access privileges (can execute the script step but get above error). These files are copies of each other, so all user accounts are the same Name and Password in both files. I am able to access files in a different database for import, have tried changing filenames but still no go. Probably something simple, but I'm stumped... Any help would be appreciated!!

Thanks, Rob

Try doing it manually first.

Thanks, I had tried that - still didn't work...

I finally stated changing accounts to see if this would have any effect. I had the Guest account "unchecked". Enabled it again and am now able to do the import. Evidently even though the account names and passwords are the same for both files, the Guest account has to be active.. (go figure!)

Thanks for the response!!

That suggests to me that it's using the guest account. Maybe the accounts and passwords aren't identical...

That's what I concluded, but I have another database with the guest account not active and it's importing fine...! (same uname/pass) Experimented some more with this & find that it's not consistent between different databases - have some with Guest active & some inactive. I thought I had it sorted out, but must be something different. I'm using the same username and password on all these... Christ!

I'll keep playing around as time permits & checking here for other possibilities.

Thanks!

Check that the account has the export privilege enabled. Check that the other privileges match.

It's definitely a privileges issue.

I have a similar problem. I have two databases that I develop on the Mac under FM9 Adv then upload to a WIN server FM9.

Both have the same Accounts and Privileges set. I have full access.

One of the databases accepts my login as normal the other gives the message "Your access privileges do not allow you to perform this action"

Note that prior to making some layout changes and re-uploading the database it worked correctly. Is there some hang over registration from the previous version impacting this?

Really frustrating, annoying and now unable to access.

In your case it's probably the OS-level file privileges on the FM Server box (as opposed to the user account privileges).

Why does it affect one file differently from the other when both are loaded one after the other?