1

Re: Installing copy of R6 on laptop

I have installed Recorder 6 on a spare machine, a laptop running on Windows 2000. I installed 6.13.2.176 from the CD and ran the upgrade to 6.14.4.212. I then ran the upgrade to Dictionary "J". Everything OK so far. At this stage I had an empty database (which I backed up). I then wanted to import the dataset from my normal working machine (also with the latest R6 upgrade). I changed the name of the backup of my working installation from its tagged name back to NBNData.bak, put it on the spare laptop and ran Restore Database. At the end of the Restore I received an unhandled error message and the choice of Continue/Restart/Close application. My only effective option was to close Recorder. When I tried to open Recorder again on the laptop I received the message "An error occurred whilst starting the application. EOleException: Cannot open database requested in login 'NBNData'. Login fails"
Looking at the tables in the database all the tables are there and populated (I think) and it looks like the restore has taken place fully. Anyone suggest how I can get back into Recorder??

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU

2

Re: Installing copy of R6 on laptop

You need to run a query against the database which enables login.

sp_change_users_login 'update_one', 'nbnuser','nbnuser'

You'll need an SQL database management program to to this. Microsoft have a free one and we also use dbamgr2k, a free download.

Graham Hawker
Thames Valley Environmental Records Centre

3

Re: Installing copy of R6 on laptop

Many thanks to you and Sally for guidance - job done

Bob Marsh
Doncaster LRC
Coleoptera recorder for YNU