"Too many fields defined" error occurred and .mdb files gets crashed, when we add & drop column to the table for MS-Access database for .mdb files in

  • Thread starter Thread starter SkyReachers
  • Start date Start date
S

SkyReachers

Guest
"Too many fields defined" error occurred and .mdb files gets crashed when we execute below sql query on table

ALTER table tbl_name ADD COLUMN Identifier int IDENTITY(1,1)

ALTER table tbl_name DROP COLUMN Setting_Identifier

from 64 bit application on windows 10 system. i am using Provider=Microsoft.ACE.OLEDB.12.0 for access with ATL-OLEDB.

one solution is there which is "compact & repair" database from the MS-ACCESS and API is also available only for the x86 in VC++.

But for the X64 bit i didn't find any alternate soultion.

Can anybody suggest solution for it.

Continue reading...
 
Back
Top