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...

Does sql agent have sufficient permissions to access the file(s)? Does it have the same network administrator permissions?

Could you repost the picture/description? My browser displays a red cross instead.

Relax

Have a look at http://www.granite.ab.ca/access/autofe.htm for possible ways of automatically updating your access-versions.

At work we have a table with program versions. At startup the Access application verifies its current version...

Something like this?

/*WILL hold names of linked servers*/

CREATE table #linkedservers

(

SRV_NAME sysname NULL /*Name of the linked server. */

,SRV_PROVIDERNAME nvarchar(128) NULL/*Friendly name of the OLE DB provider managing access to the...