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.
--
_______________________________________________
lazarus mailing list
lazarus@lists.lazarus-ide.org
https://lists.lazarus-ide.org/listinfo/lazarus

Reply via email to