How do you connect your Office SQL to your ISP SQL ?

when you  prform the change through EM you are prompted for the restart automatically

Yeah, I am not sure if he even "works" any more

Didn't you said  that you were not going to work today?

Not a big deal if you do it at INSERT time  

it most be nice not to work on FRIDAY!!!

If you have Several Names for the same ID which of the Names are you supposed to show ?

Then remove Name

Select id,  Min(SortOrder) as MinSort from @A

group by id

order by MinSort

BTW the min() will give you the minimum value within the group of columns in the group by...

Assuming the data is in a dataset (or datatable) it is still the FASTEST way

OR:

 if the number of EventID and FieldID are too many may be @SQLtring should be changed from nvarchar(4000) to varchar(8000)

I have to learn to refresh  before I post so this does not happen again

I have also to point out that whe Access open the DB it DOES checks the security settings on ADP files and allows only certain permissions to certain groups.

On MDB...

In that case the query posted by Remi should work !!

can you post an example of the output ?

Told ya!