Hi all, I want to use this code on a pc installed with ms access 2013 runtime only but it came up with runtime error.
But it worked fine on full ms access 2013 office with nil error.
I did found out that the error arose from DeleteObject.
Can I use buttons to delete table from runtime?
Or is any limitation to use VBA code on a runtime-based machine?
Private Sub Command6_Click()
DoCmd.SetWarnings False
DoCmd.Rename "Attendanceout", acTable, "Attendance"
DoCmd.TransferDatabase acExport, "Microsoft Access", CurrentDb.Name, acTable, "Attendanceout", "Attendance", StructureOnly:=True
DoCmd.DeleteObject acTable, "Attendanceout"
DoCmd.SetWarnings True
MsgBox "Attendance Erased! Kindly Return to Menu & Append New Session Details"
End Sub