Hi Internet,
I have tried to create a macro that would export all the data from one of my tables to excel , but keep running into an error message saying 'Cannot modify table structure. Another user had the table open'.
Of course I checked that nothing was open, even shuttind down the computer and going straight to the macro, but the error message keeps popping up.
Im not sure how much of difference it will mke but im using office 2003, but my database is in 'Access 2000 file format'.
Can anyone point to me a google result that ive missed, or offer some advice?
Thanks Andy_d