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

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