Jump to content
View in the app

A better way to browse. Learn more.

FMForums.com

A full-screen app on your home screen with push notifications, badges and more.

To install this app on iOS and iPadOS
  1. Tap the Share icon in Safari
  2. Scroll the menu and tap Add to Home Screen.
  3. Tap Add in the top-right corner.
To install this app on Android
  1. Tap the 3-dot menu (⋮) in the top-right corner of the browser.
  2. Tap Add to Home screen or Install app.
  3. Confirm by tapping Install.

Admin can't delete records

Featured Replies

Under what circumstances is the admin account (with full access privileges) denied the right to delete records?

I am running a script (as the developer/admin) to delete all records in several tables but not all (ie: I cannot create an empty clone). It does the job in most tables, but errors (Code 200) in 3 of them.

I cannot manually delete records from any of the 3 tables either (being warned that I don't have the correct access privileges).

Check the current account and privilege set *really* is what you expect.

Possible causes are records locked due to multi-user, or file corruption. For the corruption, start by saving a compacted copy.

  • Author

The 'empty db' script starts with a Relogin request (and exits if anyone else enters criteria), to ensure it's my account. As yet only one user and it is a recently compacted copy. No other strangeness occurring.

Could lookups be involved?

Aah - I've just tested something - there are 3 related dbs with lookups, all 3 have a seriously locked down account which 'owns' a 2-button 'Login' window - I cannot delete all records in any 1 database if either of the other 2 dbs are in that locked down account, ie: all 3 dbs have to be in my account. Obvious, well it should have been.

Thanks for your time/thoughts.

Create an account or sign in to comment

Important Information

By using this site, you agree to our Terms of Use.

Configure browser push notifications

Chrome (Android)
  1. Tap the lock icon next to the address bar.
  2. Tap Permissions → Notifications.
  3. Adjust your preference.
Chrome (Desktop)
  1. Click the padlock icon in the address bar.
  2. Select Site settings.
  3. Find Notifications and adjust your preference.