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.
 
Why do you not just open the table in design view and add the field?
 
Use VBA code to OpenDatabase().

You can then Execute the DDL query on that database.
 
You must log in or register to reply here.

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

Similar Threads

Cannot execute data definition statements on linked data sources - A2003 4
Access Form Refresh 1
Data Fields Changing 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Runtime Error 3611 2
Macro to Alter Table Field Names 14
Source data for many fields in a table from one field in another t 1
What are the steps to fix damaged MDF files in SQL Server? 0

Back
Top