Is there a way in MS-Access to delete the data in all the tables at once. We run a database in access, save the data every month and then delete all the data in access. But it requires deleting data from a lot of tables. Isn't there a simpler/easier way to do so?
Why don't you keep an empty copy of the database on hand. At the end of the month, save the existing database, then copy the empty database in its place.