[Lazarus] Dbnavigator won't post to MSACESS db

[Michael Van Canneyt]

On Fri, 8 Dec 2023, Larry Dalton via lazarus wrote:

> I am using lazarus v2.2.6 on Windows 11.
> The form uses the following components:
>  MBCCGator: TDBNavigator;
>   MBCCGrid: TDBGrid;
>   MBCCSource: TDataSource;
>   MBCC_Connector: TODBCConnection;
>   MBCCQuery: TSQLQuery;
>   MBCC_Trans: TSQLTransaction;    MBCCQuery: TSQLQuery;
>   also includes several TDBEdits.
>
>   It connects to an MSAccess Database, with a table named MBCC_2023.
>  I have no trouble accessing the database, and reading the records. I can
> use MBCCGator to navigate the database. However, it will NOT post a new
> record or a changed record to the  table. I don't get any error codes. It
> just won't  store. Help is requested.

Are you calling applyupdates and committing the transaction ?

Michael.