Here is what I had in mind: I. Create a Windows .NET EXE Application using this function that calls an asp.net web page which would do your nightly autoevent: http://www.codeproject.com/script/comments/forums.asp?forumid=1646&mode=all&userid=1587313&select=2183223&df=100&fr=2109.5#xx2183223xx[^] II. Schedule a Windows Task: 1- Go to the following menu option on the start menu: Start > All Programs > Accessories> System Tools > Schedule Task > 2- Double click on the "Add Scheduled Task" icon. The Scheduled Task Wizard will pop up. 3- Click Next. On the next screen, click the browse button and select the windows "EXE" program you just created. 4- On the next screen, choose Daily, Monthly, etc (how ever often you wish to run it) and hit next. 5- Choose the time and hit next. 6- Enter a username and password and hit next. 7- Click finish to finalize the scheduled task. That should do it. Pete Soheil DigiOz Multimedia http://www.digioz.com

Thanks for you reply, I'm not too keen on the concept from what I've looked into. I'm very old fashioned about databases and tend to use a classic ASP approach. Any suggestions on how I could use simply a globally declared application, or what the rules and capabilities are surrounding shared variables using "#include", because some pages share variables from one page to the next, but others don't. Cheers

offcourse it works and importing data is a very simple task i think just make a new database in SQL Server and right click on it > All Tasks> Import data> From data providers select MS Access, then select the Access file, give user name password if necessary and carry on with the wizard... I think that should be it :) Rocky

No wonder that you are running out of connections. You open a new connection (dbConn_DiaryPortfolioList_Check1) for every record in tblProcesses, and you never close them. Same with dbConn_DiaryPortfolioList_Check2. After that I gave up trying to follow the code. Frankly, your code is a mess. It doesn't look as ASP.NET code at all, it looks like badly written ASP code. You really need to learn how to use codebehind, server controls, repeaters, databinding, et.c. Making queries inside a loop is very bad practice. You should create a query that fetches all the data that you need for all projects at once. Read up on the JOIN command in SQL. Normally you should only need a single database connection for a page. Try to fetch all the data that you need for the page, close the connection, then put the data into the page. --- single minded; short sighted; long gone;

-Dr_X- wrote: String.Format(yourDate, "dd/MM/yyyy") A slight correction: String.Format("{0:dd/MM/yyyy}", yourDate) --- single minded; short sighted; long gone;

for(int i=0;i<n1;i++) { if(item "i" of list1 is selected) { for(int j=0;j<n2;j++) { if(item "j" of list2 is selected) { do whatever here } } } } n1->No. of items in listbox1. n2->No. of items in listbox2. Hope that helps you... Regards, Arun Kumar.A

Well, you could always search for the DSOFramer control and see if that fits your needs. the last thing I want to see is some pasty-faced geek with skin so pale that it's almost translucent trying to bump parts with a partner - John Simmons / outlaw programmer Deja View - the feeling that you've seen this post before.