this

[Quartekoen]

This is driving me insane.

Users were recently mentioning some strange behavior with one of my databases. After investigation, I found that I am unable to delete records from this database. When I try, I get the following error: "This operation cannot be performed because one or more required related tables are missing." This just started recently, and I don't know why. I've been looking through various forums (including this one, and I found many similar issues, but none quite the same), and here's what I do know:

In all my relationships in this database:

0 are related to Missing Tables

0 are set up to "Delete related records in this table when records are deleted in the other table."

0 Tables in the this database have no source, or are missing, or are in any way "unreadable"

0 Tables in any related databases have no source, or are missing, or are in any way "unreadable"

0 Tables in any unrelated databases have no source, or are missing, or are in any way "unreadable"

In all tables and Database, I am logged in as an administrator with [Full Access].

I AM able to delete a record before it is committed for the first time (such as pressing Ctrl-N, followed immediatly by Ctrl-E). After the first commit, even with no data entered into the record, I am no longer able to delete it.

I even went so far as to create a new table occurance in my relationship graph for the table that I'm getting the error for. There would be 0 relationships to this table. I would then create a new layout based on that table occurance and try to delete a record, and the error would appear again.

As far as I can tell, this is not being caused by some conflict with a primary key as mentioned here

and as I mentioned, there are no missing tables as mentioned here.

Thanks for any insights you may be able to give.

[Vaughan]

Check the record level access privileges.

[Quartekoen]

Well, I feel dumb. This has been solved.

A while ago, we were experimenting with the use of MySQL and with connecting the MySQL databases via ODBC. We decided against using these external databases, so I had been going through our various FileMaker database and deleting all the External Data Sources that used the MySQL Databases. I would also go to the Database Definition and remove any tables that used the external data sources that were listed in the table list. However, it seems that in one of the databases... I forgot one. As soon as I deleted that table listing (which of course showed "Table Missing"), everything went back to normal.

Hopefully this helps anyone else who might have a similar problem in the future. Thanks.