Hi Murdo
I managed to get the tool running on Windows 7 64 bit though not without some fiddling, so these points should help on Vista.
1) First stop your SQL Server service, because the tool tries to start it and fails if it is already started.
2) Now start a command prompt by browsing on the start menu and right click to select Run as Administrator.
3) Use cd to navigate to the folder you unzipped the tool to.
4) Open up the bat file, copy its contents to the clipboard, then right click on the command prompt and paste this in and press return.

I chose to login using my windows account rather than sa (since my sa account is disabled) and it worked.

Hope that helps, I'll add an issue to the bug list about these points.

This process should come with a very large warning sign on it. I have just attempted to run the tool and it had an entirely unexpected consequence which might have been disastrous (although hopefully I can put it right before anyone notices).

Since we originally installed R6 a good while ago, during which time there have been several updates to the database (including a number of tables I have added myself for various purposes), I've been wondering about rebuilding the Access Db to see if it would include any additional tables etc. I know I can add them myself, but I was curious (dead cats spring to mind here).

Safety first, I thought, so I renamed the existing Access Db to prevent it being overwritten, giving me a route to get back if anything went wrong.

So I downloaded the tool and ran it (having changed the default filepath as instructed). It failed to rebuild the databse (although it nicely informed me that the problem was minor and wouldn't affect the normal operation of Recorder).

However, when I looked in the Recorder/database folder, there was only one file, the new NBNData.mdb (an empty Access 97 database with no tables). My renamed copy of the original Access 97 Db had been erased, as had the converted Access 2003 version we use on a day-to-day basis (the 97 copy will only open as read-only on our system) and any other files which may have been in the folder (I don't yet know whether there were any).

Now I know I can rebuild the Database from scratch as described above, but that will not restore the numerous Access queries which we have added to the 2003 version to enable us to look at the data quickly in ways which would be much more difficult in Recorder itself.

I don't remember the last time I came across a program which erased the entire contents of a folder without warning or asking permission. I am flabbergasted!

Hopefully I will be able to restore the contents of the folder from our comprehensively backed-up system, so there should be no harm done, but this is really not good enough. The tool comes with a Read me file, but is there a warning in there? Nope.

There is of course a moral to this story, something about looking before you leap...

I have uploaded a Word Document which explains how to manually create the link.

http://forums.nbn.org.uk/uploads.php?file=Access%20to%20Recorder%206%20Link.zip