cannot execute data definition statements on linked data sources

  • Thread starter Thread starter Antoine Vuillermet
  • Start date 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.
 
Use VBA code to OpenDatabase().

You can then Execute the DDL query on that database.
 
Back
Top