I am using either the CopyObject or TransferDatabase methods to move tables, queries and forms to another database. There are no problems with the tables or queries but there are problems with the forms.
The problem is that when the code executes the code will probably work first time (not always), the second time an error will occur that states 'Object invalid or no longer set'. When I select debug from the message box the problem line is highlighted, I press F8 to single step and the line of code works fine!
Any ideas?
By the way, what is the differenec between TranferDatabase and CopyObject methods?
The problem is that when the code executes the code will probably work first time (not always), the second time an error will occur that states 'Object invalid or no longer set'. When I select debug from the message box the problem line is highlighted, I press F8 to single step and the line of code works fine!
Any ideas?
By the way, what is the differenec between TranferDatabase and CopyObject methods?
