Expand|Select|Wrap|Line Numbers
- DoCmd.TransferDatabase acExport, "Microsoft Access", "C:\Inv\ITH.mdb", acTable, "HWI", "HWI"
There is no code on this 'form_load' event on this form that references this table, there is no recordsource defined on the data property for this form. I see no where that this table is referenced or open at this point.
I have opened this application without selecting any other buttons on the main menu form and click on the 'exit database' button to try to make sure I have not opened the referenced table. I still get the error.
The users informed me that this has been happening since we upgraded to MS2007, they just have not mentioned it.
I don't understand why access thinks there the table is in use. Not sure what in 2007 could have made this not work. We were on MS2000 prior and this worked fine.
I am out of ideas. Any suggestions would be greatly appreciated!!