Help with deleting table via Access

Ok heres the situation.

I have an access data base which sits on the users personal drive. When it gets updated (not often) the user then clicks on a button to load the tables to a sql server. Views the results on the test server, then loads the tables to a live web server.

Now the code I'm using is based on one written for a much more complicated database which does the same thing successfully. I've just edited out all the bits I don't need. And it works for all but one table. It won't let me delete it prior to inserting. My question is, is it strickly neccessary to delete the old table before inserting the new one? If not I can ignore the problem of not being able to delete it.

Or if I have to delete it, what could be the possible cause of my not being able to. The only thing I can think of is the size. This table is much bigger than the others. It also contains nulls where the others don't. Could they be causeing the problems?

Any suggestions?

Because the other tables are deleting successfully, it seems likely that the table in question has some permissions issue with deletion. You might check the settings for each user in Enterprise Manager for the table you cannot delete.

Does the deletion work with your user ID?

I hope you figure it out, let me know!