logineimer

Well, I tried to open the database with permanent shift key down, i tried to do a compact and repair but nothing let me open this fu****ng database. Creating a fresh database and importing the data from the broken one didn't help neither.

I'll try my best to open the database so i can send it to you! Here is a screenshot of an error which occurs while opening the database with UCanAccess:

Unfortunately, I cannot provide the broken file because it's full of customer's data. When trying to do a "Compact and Repair Database" operation, I see the same error dialog. However, there seem to be some issues referring to the SO question. Can you guarantee that those won't happen when only reading from the database?

Hello Gord, thanks for the link! I'm not sure if this is the problem because my DDL statement does not contain an ID definition. According to the changelog, UCanAccess 3.0.6 supported basic DDL. Well, I hate this silly question: Is it absolutely necessary to define a primary key? If we don't, does UCanAccess do? CREATE TABLE [tbl_2017_08_23__15_48_53_270_test] ( [out_sql_mod7_feld3] VARCHAR(255), [out_sql_mod7_feld2] VARCHAR(255), [out_sql_mod7_id] VARCHAR(255), [out_sql_mod7_feld1] VARCHAR(255),...

Hello Gord, thanks for the link! I'm not sure if this is the problem because my DDL statement does not contain an ID definition. According to the changelog, UCanAccess 3.0.6 supported basic DDL. Well, I hate this silly question: Is it absolutely necessary to define a primary key? If we don't, does UCanAccess do? CREATE TABLE [tbl_2017_08_23__15_48_53_270_test] ( [out_sql_mod7_feld3] VARCHAR(255), [out_sql_mod7_feld2] VARCHAR(255), [out_sql_mod7_id] VARCHAR(255), [out_sql_mod7_feld1] VARCHAR(255),...

Hello Gord, thanks for the link! I'm not sure if this is the problem because my DDL statement does not contain an ID definition. According to the changelog, UCanAccess 3.0.6 supported basic DDL. Well, I hate this silly question: Is it absolutely necessary to define a primary key? If we don't, does UCanAccess do? CREATE TABLE [tbl_2017_08_23__15_48_53_270_test] ( [out_sql_mod7_feld3] VARCHAR(255), [out_sql_mod7_feld2] VARCHAR(255), [out_sql_mod7_id] VARCHAR(255), [out_sql_mod7_feld1] VARCHAR(255),...

Hello Gord, thanks for the link! I'm not sure if this is the problem because my DDL statement does not contain an ID definition. According to the changelog, UCanAccess 3.0.6 supported basic DDL. Well, I hate this silly question: Is it absolutely necessary to define a primary key? If we don't, does UCanAccess do? CREATE TABLE [tbl_2017_08_23__15_48_53_270_test] ( [out_sql_mod7_feld3] VARCHAR(255), [out_sql_mod7_feld2] VARCHAR(255), [out_sql_mod7_id] VARCHAR(255), [out_sql_mod7_feld1] VARCHAR(255),...

Hello Gord, thanks for the link! I'm not sure if this is the problem because my DDL statement does not contain an ID definition. According to the changelog, UCanAccess 3.0.6 supported basic DDL. Well, I hate this silly question: Is it absolutely necessary to define a primary key? If we don't, does UCanAccess do? CREATE TABLE [tbl_2017_08_23__15_48_53_270_test] ( [out_sql_mod7_feld3] VARCHAR(255), [out_sql_mod7_feld2] VARCHAR(255), [out_sql_mod7_id] VARCHAR(255), [out_sql_mod7_feld1] VARCHAR(255),...