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.

File Is locking up (!?) (as single user, can't add record)

Featured Replies

Scenario: FMPA8.5, started in 8

Files ;) UI, DataA, DataB

UI display a record from a table in DataA with tabs.

DataA has the usual plethora of tables for a project tracking system.

DataB, with two tables, each with a handful of fields, is only for container attachments to two tables in DataA.

In the UI file, on a button on a tab from a record in DataA, I just made a script to attach a file by going to the Files tab where a portal to DataB lies, with add record via portal ON.

Seemed happy when I shut down yesterday.

Today I decided to log in as sub accounts to do some testing, and found that the portal row would NOT add to Data B.

Using a re-login script left me with the same problem with other accounts and [FullAccess].

I went to DataB directly [FullAccess] and New record was gray out.

Quit, reopened, and it was working again through the UI [FullAccess].

Went to DataB and the opening script (it goes to blank layout and locks s.bar) said there was a navigation error as though the desired layout was missing. Couldn't get out of browse/Status locked. Couldn't get to Define Database.

Quit again, and now all is working.

It's almost as though the program is tripping over itself to access this file.

All the privs seem in order. Same for all three files, all with write access to DataB. But testing with the sub accounts and using relogin seems to have caused the issue.

The relationships are still quite simple to DataB (just the one, projects to files). Most are done from within UI, except as needed for local field calculations in the data tables (Two in DataB Project[=]Files, Files[x]UI).

BTW - network sharing is off.

*

It occurs to me NOW this whole thing may because I re-logged in to one file, UI, but perhaps that confused the other open files as they were not "relogged-into"?

And perhaps my lowliest priv set to DataB is not allowing record creation? time to RTFM I guess. Hmm, but I had QUIT in between, so access to DataB should have been full...

Many thanks for your 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.