SQL Server probably needs an extra object with rowinformation (primary key, (non)unique index) in order to enable rowlocking.

With no index, sql server can only lock the table/page as a whole...

Got it working using

sp_addlinkedserver @server = 'SRVEXTRA'

, @srvproduct = 'SQLSERVER'

, @datasrc = 'BRANDNEW\SRVEXTRA'

...

In other words.

There is an application MyAPP thats needs info from the database "operation" on server SRVOPS (2000), default instance SRVOPS

It also needs information from database "EXTRA" located on...

Torhout, Belgium

Task manager isn't reliable above 2gb. Try Process Explorer or performance counters.

What does PF stand for? (page faults?)

I'm not familiar with DTS nor the "b" parameters.

I suspect that strList is passed as a string instead of a rowset/table. (for the in clause)

Like in ('abc,ddfdfqd,dfdfqdfe')

You can resort to...

where does the come from?

*How to convert this Left([Field3],InStr(1,[Field3]," ")-1)

LEFT([FIELD3],PATHINDEX(' ',[FIELD3])-1)

*Right([Field3],(Len([Field3])-InStr(1,[Field3]," "))) & [Field4]

RIGHT(FIELD3,LEN(LEFT([FIELD3],PATHINDEX(' ',[FIELD3])-1))+[FIELD4]

(if FIELD4 is also character)

Nice point of view, luckily not all announcements are written is this way.

Really stupid things in my junior dba-years:

Dropping the wrong table in a 40gb database. Sure I'm on the testserver.

Update without where clause (where's my history table)

Merry Christmas!

You could recreate the view on the serverbackend and relink the view afterwards in Access.

This should be done whenever underlying datastructure changes, since views in sqlserver keep the definition of...

You can union both results together

select EmpID

,LName

,FName

,Role

,FileID

,FileNo

,SectID

,AttyID

,FileName

,DateOpened

,Dept

,Status

,Desc

from employees

inner join files

on empid=sectid

union all

select EmpID

,LName

,FName

,Role

,FileID

,FileNo

,SectID

,AttyID

,FileName

,DateOpened

,Dept

,Status

,Desc

from employees

inner join files

on empid=attyid

order by empid

Is the table definition in Access updated?

Thanks for providing the sample data.

I didn't find anything odd in query analyzer (still the same 13 records)

Yet some notes:

*The view uses TOP 100 PERCENT

This can be removed as sorting...