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

run sp_server_info @attribute_id =2, that attribute tells which edition of sql server you are connected to

You can fill the server variable with a loop. (cursor) SET @ServerID=@OtherVariable

Can you write a couple of statements of wanted output for the statement to execute?

You can use bulk insert also. It's only named bcp-file (c:\bcptest.txt) because I've exported the data with bcp.

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