Problem. I have a vba routine to make certain tables. The routines run and on stepping through I see the usual system messages:
'You are about to run a make-table query.............etc'
'The existing table ..........etc'
'You are about to post ........etc'
But two of the make table query's get to 'The existing table will be deleted.....' and skips over 'You are about to paste.....'
The two mktable query's in question look at a different database via linked tables.
If I manually run the two querys by double clicking them in the editor they work fine.
Code: Select all
'DoCmd.SetWarnings False
DoCmd.OpenQuery "mktblStaff", acViewNormal, acEdit
DoCmd.OpenQuery "mktblAttPeriod", acViewNormal, acEdit
DoCmd.OpenQuery "mktblHoliday", acViewNormal, acEdit
DoCmd.OpenQuery "mkTblWorkGroup", acViewNormal, acEdit
DoCmd.OpenQuery "mkQryAdditionalRef", acViewNormal, acEdit
DoCmd.OpenQuery "mkQryCourtesyAvailability", acViewNormal, acEdit
DoCmd.OpenQuery "mkQryDBA_VR_HireHistory, acViewNormal, acEdit"
DoCmd.OpenQuery "mkQryJCVExport", acViewNormal, acEdit
DoCmd.OpenQuery "mkQryWorkshopControlFit", acViewNormal, acEdit
DoCmd.OpenQuery "mkQryWorkshopControlPaint", acViewNormal, acEdit
DoCmd.OpenQuery "mkQryWorkshopControlPanel", acViewNormal, acEdit
'DoCmd.SetWarnings True
Cheers