DoCmd.CopyObject fails when run from Word VBA

B

Bo Hansson

I'm trying to copy tables from one database to another by means of
DoCmd.CopyObject, run from Word VBA. But the result is'nt what I expected.
Freely translated from Swedish I get a run time error (2486) that says:
"This action cannot be performed right now"

My question is: WHEN can I do it ? ...... and: what's wrong ?


/BosseH
 
V

Van T. Dinh

Are you automating Access (as server) from Word (client)?

If you are, I think you can use:

objAccessAppln.DoCmd.CopyObject ...

where objAccessAppln is your automated Access application.
 

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

DoCmd.CopyObject Error 2501 3
VBA-Table Word 2019 - Move a selected text, from a cell to the adjacent cell to its right, by pressing the ENTER key 0
Setting sort order from Word VBA 1
Creating table from Word VBA 2
Spell Check and Mergefields not working 1
Run code from another workbook 7
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
hyperlink fails to open 1

Top