Problem with Flexsim 4.1 and Access DB

HI @all!

We have a problem with Flexsim 4.1 and Microsoft Access Database.

In the model TestDB.fsm (see attachment) we use a source, a transporter and a sink. In the source there is a DB connection to the access database FlexsimTestDB.mdb via the ODBC driver AccessFlexsimDB.

In the source (OnExit-Trigger) there is the following flexscript:

string ODBCname = "AccessFlexsimDB";
string query = "";

dbopen(ODBCname,"SELECT * from DBTable",0);
query = concat("INSERT INTO DBTable ([ID]) VALUES (4)");
dbsqlquery(query);



If we will change/open the code dialog - after running the model once - Flexsim will freeze or crash when we close the dialog again.

We tried different changes (try/catch block, other computers, …) but there is nothing what fit. The problem may is the INSERT-Statement. It’s not possible to upgrade Flexsim to 4.3!

Does anyone have a clue or a work around? It’s really important for our customer!

Thanks a lot and best wishes
Martin