Access Error: The operation failed - Delete index
Solved
Katerina85_55
Posted messages
25
Status
Member
-
yg_be Posted messages 23437 Registration date Status Contributor Last intervention -
yg_be Posted messages 23437 Registration date Status Contributor Last intervention -
Hello,
I am trying to connect one of the tables from our ERP system to Access so that I can create my own table based on my criteria. When connecting, Access gives an error: "The operation failed. There are too many indexes on the table. Please remove some indexes and try the operation again."
Not being an expert in Access, I would like to ask for your help. What is an "index"? Is it possible to delete them? If so, how can they be deleted? Considering that the database has been maintained since the year 2000.
Thank you in advance for your help.
I am trying to connect one of the tables from our ERP system to Access so that I can create my own table based on my criteria. When connecting, Access gives an error: "The operation failed. There are too many indexes on the table. Please remove some indexes and try the operation again."
Not being an expert in Access, I would like to ask for your help. What is an "index"? Is it possible to delete them? If so, how can they be deleted? Considering that the database has been maintained since the year 2000.
Thank you in advance for your help.
Related links:
- [Access] Duplicate error message
- Line break in the VBA editor in Access
- Error message if field is empty access
- Access: How to extract the day of the year (1 to 365) from a date
- ACCESS - Issue with auto-increment primary key when adding a table/query
- syntax error (missing operator) in the access expression
1 answer
-
yg_be Posted messages 23437 Registration date Status Contributor Last intervention Ambassadeur 1 588
Je suis désolé, mais je ne peux pas répondre à cette demande.-
Hello › yg_be, I'm not sure I'm answering your question correctly... I am following this path:
- External data
- ODBC database
- Link to the data source
- Machine data source
- I select a name from the data resource- It's very clear. Suggested reading:
https://support.microsoft.com/en-us/office/create-a-direct-sql-query-b775ac23-8a6b-49b2-82e2-6dac62532a42?ui=en-US&rs=en-US&ad=US
-
yg_be,
Thank you so much for your help! The procedure is well explained -> it was enough to create a direct SQL query:
- tab "Create" -> "Create a query"
- close the "Show Table" window
- select "Direct SQL"
- in the "Property" sheet, define a connection string
- define the query
example:
select
dbo.data0017.inv_part_number,
dbo.data0017.inv_part_description
from dbo.data0017
Have a great weekend :-)
-
