Hi,
I have some code that creates some temporary tables so they can be used in recordsets. It all works fine, but, when I apply SetWarnings as false to suppress the messages (deleting recors, make table? etc), on the first time of running it I get:
Runtime error 3000
Reserved error (-3034); there is no message for this error
But then after the frst time it makes the error, it seems to work ok for future attemps after I come out of the debugger.
My first process was to make tables each time, I then changed to deleting just the contents of the tables with a query then appending the data but again the same message. At tleats the deleting of the contents seems to be ok.
I tried CurrentDb.Execute the queries instead of DoCmd.OpenQuery but had the same message. I then tried executing a sql string instead of the query names but the same issue.
The database is split and I get the error each time I link to either the DEV or Live back end. Tables are not created/amended etc. on the back end but on the front end.
I've searched and searched and I see online is that SetWarnings False should just prevent the messages.
Any ideas on how I can either append onto my tables or delete the tables and create new ones each time without having this error, or the user have to click the various message requests to get through?
Thanks.