I have 3 table in dbf format that I want to transform to .db. The Tool I use is ms Access.. I import a table from dbf and then I export to .db.
First Error I have is "Index is read only" when i want to edit a register in delphi 6.
Then I read more and I found that I have to put maintened in database desktop. But I have the problem that the field index_id (primary key)(autoincrement) have no data, and when I save the keyviolate.db appear with the major of records.
What I am doing wrong? What tool i need to transform?
Structure I Have in dbf: