Having a Table-field on a Dashboard while the Table needs to be modified

[BigDDDD]

Good Day and Thank You for whomever tries to help me.



I have a Sales table that is appended every week with new records. One of the fields in this table, we will call "Week". Data that I appended on Monday was for week 201446. Next Monday will be Week 201447. I have another table, called maxweek, that reads the Sales table after every week gets processed, telling me the max value in the Week field. I need this second table to be used in multiple join queries that are used later in the week.

All of this has worked perfectly for years for me until I tried to make a helpful text object on a form that is used as a Dashboard. I want the users, when they open the db, to visually see what was the last week of sales appended into the Sales table. The problem....the macro that loads my new sales every week and then recreates the maxweek table has a conflict. The Dashboard is looking at the maxweek table and therefore does not allow it to be deleted (and then recreated.)

Does anyone have a clue how to resolve this without VB code? I'm afraid that my VB skills are less than my Access skills.
Thanks again.

[June7]

Don't delete and recreate table (this a db design change and really not good idea to program this into a routine process) - just delete records and import new records to existing table.