I need some suggestions. I'm new to asp database programming. I have an asp page that will upload a text file to the server and replace the current data in an Access table with data from the text file. I'm using DNS-less connection. This won't be a busy site. There will be approx. 400-600 records.

1. What is the best method/order of doing this. For example, should I delete all records from the table and then just insert all the new ones? -or- Create a temp table with new data (because adding the new data to the db will be the longest operation), delete the old table, then rename the temp table? etc?

2. Should I be concerned about any connections that may be present on the database before I delete/change the database? Will I get an error when deleting/updating if someone is connected to it?

You could just have your app read the text file and update the Access table without having to upload the file to the server, unless that is one of the requirements someone else has ordered, if I'm understanding you correctly. It sounds like you're going to delete the data in the target table and replace it with the data that's in the file. Of course it depends on other factors like if there is relational data in other tables that will be referencing the data in the target table.

You won't get an error but someone else might if they are looking at a page with data that gets deleted and then they refresh the page. Other than that there shouldn't be a problem with that.