Good Work Everyone. There is a database with dbf extension given for Common Use. I can open the database with access and right click and delete the row, but when I want to delete it with a query, I get an error. error:Too many fields defined. There are 457 columns in the table and unfortunately it is impossible for me to reduce the number of columns. I can right click and delete but why am I getting an error with the query, it's hard to understand

CodePudding user response：

Access has a hard maximum of 255 fields (source).

If you can't reduce the number of fields, Access is not the right database for this data. It is odd that you can do anything with this table (dbf is also not an Access extension).

CodePudding user response：

There are 457 columns in the table

There is no way Access can handle more than 255 fields in a table or query.

So, somehow get a tool that deals with dBase files directly and use this split the table into two, both having the primary key included.