Hello.
I have problems with making DDL Queries to linked table.

I opened the recordset (Access linked table) with ADODB.Connction and ADODB.Recordset in Excel and made a DDL Query to that recordset: CREATE INDEX,
but received the error message:
Error: -2147467259-[Microsoft][ODBC Microsoft Access Driver] Cannot execute data definition statements on linked data sources.

How can I solve this problem?

Should I create "clone" of linked table before making query or is it possible to allow
make DDL queries (like CREATE INDEX, DROP INDEX,...) to linked tables (in VBA)?

Jüri Kuusik.
[email protected]

If you are able to make an index on the table using the menu system of Access then you should be able to do the same through code.
If the options to create an index are not available trough the Access interface, then you will not be able to do this through code either.

If that is the case, then your Access option is to import the table data into an Access table and index that, or create an index in the DBMS from which the tables(s) are/is linked.

Are you able to make an index through Access' design system?