cannot execute data definition statements on linked data sources

  • Thread starter Antoine Vuillermet
  • Start date
A

Antoine Vuillermet

Hi all !

I'm working on several databases.

I would like to execute a macro in main_database, to open
second_database and add a field to one table.

My macro can control some fields in second_database and execute subs in
function of the controls, but when it comes to adding a field to a table
(via a SQL command), I get the error #3611 message...

Can you give me some details on how to solve this problem ?

Thanks a lot !
Antoine.
 
A

Allen Browne

Use VBA code to OpenDatabase().

You can then Execute the DDL query on that database.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top