Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Running Delete Query as page loads

Status
Not open for further replies.

Pistol

MIS
Jan 29, 2001
59
US
I know this can be done, but I'm very new at it and having a hard time with it. I have a page that displays the results of an Access database table. When that page loads I want it to run a query to delete expired records before it loads the table.

I imagine that I need two ASP files to do this, and a way to call, or include the delete page before the initial page loads.

Any Suggestions?
Thanks
Pistol
 
my suggestion is to exclude the expired records in the your SELECT-statement of your query. br
Gerard
 
That would work, but then I would still have to run the delete query in the database on a regular basis
 
i 'reorganize' the database by calling a stored procedure (from the web page) br
Gerard
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top