How to run and schedule SQL statements

J

Jack Ling

HELP: How to use ASP.NET to run scheduled SQL statements?
Posted: 06 Aug 2004 02:54 AM
Hi,


I've some SQL statements to be scheduled daily to run.
Theses action queries are to append some records to an
Access database table.

Question:
- How do I schedule a take to run in background, and
scheduled to run the append SQL statements by itself?
- the system doesn't have Access installed. Is it ok juz
intstalling MS Data Access componenets?

thanks in advance,
jackling
 
M

M.L. Sco Scofield

Sorry. You are in the wrong group.

All of the "microsoft.public.access" are for when you are using the Access
program.

If you are using the Jet data in an mdb file from ASP.NET, this is an
ASP.NET issue.

For your .NET questions, try one of the 49 .NET groups that all start with
microsoft.public.dotnet.

For ASP.NET specifically, I'd try one of the 9 ASP.NET groups that all start
with microsoft.public.dotnet.framework.aspnet.

For .NET data issues, I'd try microsoft.public.dotnet.datatools or
microsoft.public.dotnet.framework.adonet.

Good luck.

Sco

M.L. "Sco" Scofield, Microsoft Access MVP, MCSD, MCP, MSS, A+
Useful Metric Conversion #17 of 19: 1 billion billion picolos = 1 gigolo
Miscellaneous Access and VB "stuff" at www.ScoBiz.com
 
Top