Invoking Queries Online

[magmike]

I have created a query that deletes blank records (i have controls that do
not allow blank entries on the web form, but somehow, i still get a ton of
them - robots, maybe?). However, I have to use it with the database open,
and then upload the corrected database to the server. I am hoping to be able
to create myself a link on my 'admin' page, that would invoke this query on
the server.

Can this be done?

mike

 

[[MVP] S.Clark]

Perhaps if you explain your architecture, we can deduce an answer.

 

[magmike]

It's pretty simply, actually. The database has one table - no relationships
whatsoever. There are a couple of queries that are for reporting function
only. They are not used in the html, and they are typically just used when I
have downloaded the database and open it live. The delete query, when run,
deletes any record in the table that has a blank TITLE field. I use ASP to
call up results in html. I'm on a Windows server. Was there anything else
you needed to know?

Mike