Marciel Degasperi

The proposed implementation is really complex. To populate the combobox, the app needs to know exactly which table the field belongs to in order to identify the foreign key. The problem is that once Delphi processes a SQL command, it does not preserve the source table name for those fields. Without this information, we cannot automatically retrieve the relationship required to load the option list.

Error: Access violation at address 76E47859 in module 'ucrtbase.dll'. Write of address 123BC000

I was unable to reproduce this issue. Please note that while you mentioned a Windows 11 update, MDB Admin is running on Windows 7 Ultimate, likely within a virtual machine. In this setup, updates to the host operating system do not affect the virtual environment. If the problem persists, please open a new ticket with additional details, preferably including your database file.

Data

Error: Item cannot be found in the collection corresponding to the requested name or ordinal

This issue occurs because Microsoft Access does not support the FULL JOIN clause. Unfortunately, the current error message is generated by the database driver itself, so I cannot modify it to be more user-friendly. You will need to rewrite your SQL query using supported clauses. You can find the list of compatible commands in the official Microsoft documentation at https://learn.microsoft.com/en-us/office/vba/access/concepts/structured-query-language/perform-joins-using-access-sql.

You can use the F9 key to run a query. Unfortunately, I don't yet have documentation for MDB Admin, but you can send your questions here and I'll be happy to help.

Improvements to the "View/Edit Data" mode.