I'm no expert, and there's probably an easier way, but I use something similar to the following in one of my databases:
DoCmd.CopyObject, "myTableOld", acTable, "myTable"
DoCmd.DeleteObject acTable, "myTable"
In effect this creates a copy of the original table and you then delete the original...
Many thanks for all the tips in this thread. I started experiencing this problem this morning on a stand-alone database and couldn't work out what was going on. A Google search brought me here so I uninstalled Adobe Acrobat 7.03 professional and it sorted the problem. I re-installed Acrobat...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.