A guess in the dark: Remote registry service disabled?

An access project doesn't Dao I believe. You might be looking in the wrong section.

If Errors.Count > 1 Then

For Each errX In Errors

         Debug.Print "Error"

         Debug.Print errX.Number

         Debug.Print errX.Description

      Next...

it works. Tested with

CREATE TABLE test

(

[NO] varchar(50)

, FormerNO varchar(50)

, Surname varchar(50)

, Forename varchar(50)

,NameOrderIndicator  varchar(50)

, MiddleNames varchar(50)

,DateOfBirth varchar(50)

, Gender varchar(50)

,FormerSurname varchar(50)

,PreferredForname varchar(50)

, PreferredSurname varchar(50)

, PreferredNameOrderIndicator varchar(50)

, ETH varchar(50)

, ETHSource varchar(50)

, T1...

Have you tried (erase the blank line (forum))

8.0

39

1 SQLCHAR 0 255 "," 1 NO Latin1_General_CI_AS

2 SQLCHAR 0 255 "," 2 FormerNO Latin1_General_CI_AS

3 SQLCHAR 0 255 "," 3 Surname Latin1_General_CI_AS

4 SQLCHAR 0 255 "," 4 Forename Latin1_General_CI_AS

5 SQLCHAR 0 255 "," 5 NameOrderIndicator  Latin1_General_CI_AS

6 SQLCHAR 0 255 "," 6 MiddleNames Latin1_General_CI_AS

7 SQLCHAR 0 255 "," 7 DateOfBirth Latin1_General_CI_AS

8 SQLCHAR 0 255 "," 8 Gender Latin1_General_CI_AS

9 SQLCHAR 0 255 "," 9 FormerSurname Latin1_General_CI_AS

10 SQLCHAR 0 255 "," 10 PreferredForname Latin1_General_CI_AS

11 SQLCHAR 0 255 "," 11 PreferredSurname Latin1_General_CI_AS

12 SQLCHAR 0 255 "," 12 PreferredNameOrderIndicator Latin1_General_CI_AS

13 SQLCHAR 0 255 "," 13 ETH Latin1_General_CI_AS

14 SQLCHAR 0 255 "," 14 ETHSource Latin1_General_CI_AS

15 SQLCHAR 0 255 "," 15 T1 Latin1_General_CI_AS

16 SQLCHAR 0 255 "," 16 T1Source Latin1_General_CI_AS

17 SQLCHAR 0 255 "," 17 N1 Latin1_General_CI_AS

18 SQLCHAR 0 255 "," 18 R1  Latin1_General_CI_AS

19 SQLCHAR 0 255 "," 19 CountryOfBirth Latin1_General_CI_AS

20 SQLCHAR 0 255 "," 20 C2 Latin1_General_CI_AS

21 SQLCHAR 0 255 "," 21 LLL Latin1_General_CI_AS

22 SQLCHAR 0 255 "," 22 DDDLatin1_General_CI_AS

23 SQLCHAR 0 255 "," 23 DEW Latin1_General_CI_AS

24 SQLCHAR 0 255 "," 24 HTW Latin1_General_CI_AS

25 SQLCHAR 0 255 "," 25 Address1 Latin1_General_CI_AS

26 SQLCHAR 0 255 "," 26 Address2 Latin1_General_CI_AS

27 SQLCHAR 0 255 "," 27 Address3 Latin1_General_CI_AS

28 SQLCHAR 0 255 "," 28 Address4 Latin1_General_CI_AS

29 SQLCHAR 0 255 "," 29 Address5 Latin1_General_CI_AS

30 SQLCHAR 0 255 "," 30 PostCode Latin1_General_CI_AS

31 SQLCHAR 0 255 "," 31 PhoneType Latin1_General_CI_AS

32 SQLCHAR 0 255 "," 32 PhoneNumber Latin1_General_CI_AS

33 SQLCHAR 0 255 "," 33 TYE Latin1_General_CI_AS

34 SQLCHAR 0 255 "," 34 SSR Latin1_General_CI_AS

35 SQLCHAR 0 255 "," 35 SSR2 Latin1_General_CI_AS

36 SQLCHAR 0 255 "," 36 CYUU Latin1_General_CI_AS

37 SQLCHAR 0 255 "," 37 CYUU3 Latin1_General_CI_AS

38 SQLCHAR 0 255 "," 38 CYUU4 Latin1_General_CI_AS

39 SQLCHAR 0 255 "\r\n" 41 Importdate Latin1_General_CI_AS

My testing procedure which works. You only have to modify the window login section. With a simple cursor you can fetch each login & execute the stored procedure.

CREATE PROCEDURE dbo.UCreate_QW_Logins...

My formatfile knowlegde isn't so good either. Sql server is quite picky in its format files. Terminator "\r\n" tells it should go to the next line.

A small resume:

The target...

You could shedule a job for this that reads from the log tables and adds the users.

You will need dynamic sql for this

DECLARE @Statement nvarchar(2000)

SET @Statement =N'SELECT '+ convert(nvarchar(150),@server_id) + N' as [Server] ,

plunum,

pludesc,

from '+ convert(nvarchar(150),@server_id) + N'.backoff.dbo.plu'

EXECUTE master.dbo.sp_executesql @Statement

if there are no rows present:

DBCC CHECKIDENT (yourtablename, RESEED, 0)

from the books online:

Basically it works like

Fill column1 with all you find till it hits the "," character

Fill column2 with all you find till it hits the "," character ...

So the last column...

if you put all 6 in a array, you can use a sorting algorithm to order them from low to high.

http://en.wikipedia.org/wiki/Sorting_algorithm

Average maximum=average of the 3 highest numbers, average minimum=average...

I work 38 hours a week with flexi-time. Life is more than work alone.

For sql server 2000 it is best to patch to service pack 3a or higher, this to fix many bugs.

By applying the service pack there is also a great chance...

@@Servername is not null?

Have you applied any sql server service packs?