We aren't there.  We can't see what you've already tried.

Please post the SQL statement of one of your DELETE queries.

You can't do that with a single query.

You could do it with a series of Executes in VBA code, e.g.:
   Dim db As DAO.Database
   db.Execute "DELETE FROM Table1;", dbFailOnError
   db.Execute "DELETE FROM Table2;", dbFailOnError
   'etc.

However, you will need to bear in mind the way your relationships work. If
there is a one-to-many relation between Table1 and Table2, the above will
fail because the Table1 records cannot be deleted while the Table2 records
exist (unless you have set up cascading deletes.)

You may need to ensure you don't have circular cascading deletes on your
tables.

I'm not sure I understand the purpose of having a database if you are going
to delete all of the data every day.  Can you explain why you think you need
to do this?

Dale