Tables are created no problem by a set of make table and append queries IF they are run right at the start of application. However, once data were handled by forms and data are changed the same queries are caught in the debugger saying that they cannot be run because the data are handled by another user. That happens despite all the froms are closed when rerun is attempted. I tried all I could but nothing works and it makes no sense. I am tearing hair out.
-
-
Access will only lock a table if something bound to that table - a query for instance - is open, or another object such as a form based on that table remains open.
Without seeing the code involved it is difficult to offer an opinion, other than to say the debugger will be telling you the truth - there is something bound to that table which is still open at the time you are attempting to run the make-table query. Are you sure you have no queries on that table open? Are you sure that you have closed any OpenRecordset methods called by the form you tell us you have closed?
Without seeing the code concerned I am unable to comment further at present.
-StewartLast edited by Stewart Ross; Feb 8 '17, 04:33 PM.
Comment