achrafus wrote: the odbc driver it says not enough parameters or something. That's a bit vague - What is the EXACT error message? (From other things you've said I think I know what the problem is, but this kind of vague reference to an error message really is not useful and can irritate many people. There are often two similar error messages where the actual root cause is substantially different) achrafus wrote: In my string i'm having only one parameter and it's @catName Access does not use named parameters, use ? (the question-mark) and add the parameters in the order they appear in the query. "On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question." --Charles Babbage (1791-1871) My: Website | Blog

Should be this...? myCommand.Parameters.Add("catName",categoryName.ToString());

Your problem seems to be a perfect candidate for the BackgroundWroker thread control that's newly available in the .NET 2.0 framework. Using this controll is rather pain free. It's literally a matter of a few click to get yourself set up with a background worker thread that is going ot perform the scan in background for you. The way you use this control is you have to provide three functions to handle three events. One is the actual worker function (this will be the function that scans the files). Then There is a function that will be called when the progress changes. And the last one is going to be a function that will be called when the thread ahs finished processing. So in the actual worker function you will need to call the ReportProgress function that will basically marshal your call and eventually fire the second event (the progress changed event) on the appropriate thread. It's that easy. Feel free to google for the BackgroundWorkerThread samples online Good luck Mikk ---- www.muzikstor.com

thanks for your answer, I checked the project output it's set to class library. I think the problem comes from the fact that when trying to register the dll using regsvr32 it does not find DLLRegisterServer entry point. the msg I got is mydll.dll was correctly loaded But the DLLRegisterServer entry point was not found. Unable to register within windows. (I got the msg in french , I think this is the eng version.) I didn't know that I'll need to have the .net framework installed on my clients

One note I would like to add to the other respondents. I am not a big fan of using operators when comparing datetimes. If, for example, one of your parameters is using GetDate() (sql server) the <,> etc operators check the time. This can lead to very undesirable results! If you are not interested in the time, it is better to use DATEDIFF(dd,date1,date2) < 0. You'll find yourself chasing down less problems this way.

Triggers cannot be scheduled. Triggers get fired only when you delete, update or insert data on a table with triggers.

thank u Mr Mackay, my tables look like this inhabitant ---------- inhabitantId ... info about inhabitant Appartment ---------- AppartementId inhabitantId Amount //the amount that the inhabitant shoul pay monthly Payement --------- inhabitantId AmountPayed //the amount payed is what's paid each month if done date //date the the paid amount PostponedPayement ----------------- InhabitantId amountdue Referencedate //the reference of the unpaid month I need to get the inhabitants that didn't pay for each month and store these in my PostponedPayement table. for example Appartement Inhabitant Payement --------------------| ----------------| ---------------------------- ApptId inhId Amount| InhID | InhaName| inhId |paidAmount|Date --------------------| ------|---------| -------|----------|--------- 177/R1 inh1 150 | inh1 | James | inh1 | 150 |01/08/2005 177/R2 inh2 180 | inh2 | Jone | inh4 | 100 |05/08/2005 177/R3 inh3 150 | inh3 | Greg | 177/R4 inh4 100 | inh4 | mike | in my PostponedPayment table I need to get this for august payments plus what is left from other months PostponedPayement ------------------------------ InhabitantId|AmountDue|Refdate| ------------|---------|-------| inh2 | 180 |08/2005| inh3 | 150 |08/2005| inh1 | 150 |06/2005| I did the following query to get all those who paid and those who didn't : select Appartement.ApptId, date, Payement.Amount from Appartement left join Payement on Payement.ApptId=Appartement.ApptId I get the following --------------------------------- InhabitantId|Amount | date | ------------|---------|----------| inh1 | 150 |01/08/2005| inh4 | 150 |05/08/2005| inh2 | Null | null | inh3 | Null | null | all I need to pik up are the 2 last values in the example and insert them into PostponedPayment Hope it's clearer now!excuse my English But I thank yu very much Thanks to all those who help and those who try to help