I have a csv file that I download from a remote server every morning at 8am.
This is imported in access and written to an Access table on one of the servers, having first deleted the previous days version of the Access table.
The importing of the csv and then the outputting to the Access table takes less than 5 minutes, but the deleting of the records in-between from the discarded table is taking upto 50 minutes....
kilabyte
Last Activity: Nov 6 '08, 10:20 AM
Joined: Oct 17 '08
Location: Wigan
-
How do I speed up an Access (SQL) Delete all records
-
Superb, thats exactly what I was looking for.
I was sure an easy way must exist.
Thanks for the help. -
Thanks for the reply, but not a solution to my problem.
Sorry probably not explained myself well.
I know how to turn the summary on and off.
What I need to do is detect whether the summary is actually displaying validation text (IE. validation errors are present on the page). If it is then I want to return out of the sub and not proceed until all the fields are correct filled in by the user.
...Leave a comment:
-
kilabyte started a topic How do I check all validations ok before proceeding using Visual Studio 2008in .NETHow do I check all validations ok before proceeding using Visual Studio 2008
Hi,
First post on here, I can't see that the question has been asked before.
I am new to Visual Studio 2008 (using VB), but a seasoned programmer using Access and VBA.
I have created a web site in VS and a form that the user fills in on a web page. The results are written to a record on a server once the send button is clicked on.
10 items on the screen are validated (is a named entered,...
No activity results to display
Leave a comment: