Import data from SharePoint - overwrite current table?

Question

I am working with an Access database in which I have imported some SharePoint lists for the purposes of creating reports in Access.  I need a way to update the data frequently.  The import action creates a new table by appending a number to the end of the table name.  Is there someway have it update/overwrite the current table so that the reports can continue to run?  Ideally, I want this action to be triggered by a button running an embedded macro.

I should add that using a linked table from Access is not an option for me.  I keep getting an OutOfMemoryException error anytime I try the linked tables.  I don't think our SP server is up to the task.

I also thought I could make my macro delete the object (table) and then running my saved import, but I do not see DeleteObject in the list of available actions.

Answer 1

I need to resume researching a way to overwrite my table after all.  Is it possible,?

Answer 2

I solved this by putting the embedded macro button on it's own form which is a subform in my navigation form.

Answer 3

I figured out how to make the "missing" actions show up.  So I created my macro to delete the current table and import a new one.  However, when I try to run it, I get "The database engine could not lock table " because it is already in use by another person or process."  This seems like a catch 22 because the embedded macro is on the page with the form that when run will use the table.  Any way around this?