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]

You have to open the connection against the backend database where the actual tables reside - not the frontend where the linked tables are.

Graham R Seach
Microsoft Access MVP

Thanks for suggestion!
Do You mean that I have to open in VBA Access file (source file),
then create index for the table, which is in the that Access file,
and then some make a query to table, which is linked to source Access file,
and then delete the index from the source Access file?



Jüri Kuusik.
[email protected]

In VBA, you have to open the database that contains the actual tables (not the linked tables), and execute the DDL queries against the actual tables in that database.

This kind of question is not related to the book. You really should direct this type of question to the appropriate forum. I suggest posting such future questions to the Microsoft product-specific newsgroups. See the following page for instructions on how to connect to the Microsoft newsgroups.

http://www.pacificdb.com.au/MVP/newsgroup.htm

Graham R Seach
Microsoft Access MVP