not sure if it will work, but you will need an error check too at

OPEN C_TESTE

 FETCH NEXT FROM C_TESTE  INTO @CONT

->error check

Can you give some textual output data?

Some things that might improve:

Union -> Union All

Rewrite CONVERT(varchar(10),ud.[date],110)=CONVERT(varchar(10),i.[itdate],110) to use BETWEEN instead of performing a function on a column

Does it work when you write a parameterquery (as a query object) and use that query for the recordsource?

Is vwIndivPTMFcastbyProject a linked table or do you

use T-SQL?

Can you output debug.print strSQL or msgbox strSQL to verify strSQL?

Have you installed/reinstalled mdac 2.8? A newer version of mdac is already included in windows xp servicepack 2

Found a link on possible related error 126:

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=91285&SiteID=1

pity me, I switched deleted (previous data) with inserted (new data)

CREATE TRIGGER TR_TEST_MANDATORY ON dbo.TEST for UPDATE, DELETE

AS

SET NOCOUNT ON

IF EXISTS(SELECT col1 from deleted /*old data*/ WHERE col1 in ('one','five'))

BEGIN

ROLLBACK TRANSACTION

END

Now...

Goodday Homero

Could you try the following:

Making sure all previous installations are removed:

*No antivirus/antispyware program are running and that all sql server services are stopped.

Microsoft has some detailed steps on manually removing sql...

The condition is still

If you update or delete where col1 is one or five then rollback the transaction ?

The current code wants that one of the records contains col1=1 or 5,...

CREATE TRIGGER TR_TEST_MANDATORY ON dbo.TEST

AS

SET NOCOUNT ON

IF EXISTS(SELECT col1 from inserted WHERE col2 = 'mandatory')

--IF EXISTS(SELECT col1 from inserted WHERE col1 in ('one','five'))

BEGIN

ROLLBACK TRANSACTION

END

Does in only have to be 1 level deep?

SELECT TableA.ID,TableA.ParentId,TableB.ChildName

from TableA Parents

LEFT join TableB Childs

on parents.id=childs.parentid

order by parentname,childname

(still needs some testing)

You're welcome.

If you connect to the windows xp from another computer you may run into the maximum allowed inbound connections of windows xp: http://support.microsoft.com/?scid=kb;en-us;314882

Windows home:5

Windows pro :10

The optimalisation job is problably DBCC REINDEX (hold locks)/DBCC INDEXDEFRAG(online)  (keeping indexes in shape, fills log quite nicely) en perhaps sp_updatestats (for a better query plan).

Log backups can be done...

I have no experience with switchboard but they look like forms with button. When clicking on a button it opens a new form (see the visual basic for applications code)....

You mention the transaction log becoming full. Does it grow in small enough increments. Is the initial size large enough to prevent shrinking/growing.

During the optimization job, is the database mode...