We are having a problem importing data to our (otherwise fully functional) copy of Recorder 6 running on SQL Server 2000.

I have successfully imported hundreds of thousands of records from Excel using the import wizard and thought I had a pretty good feel for it, then I passed the job over to another member of staff (because I had other things to do). On her first attempt at a full import (fortunately of only a small dataset) she got all the way through every stage of the wizard, up to the "Do Import" button at which point there was an error generated with the exception message "File access denied" (the full text of the error dialog is reproduced below).

As far as we are aware she has the same access to the database as do I (same Rec 6 settings, same SQLServer permissions etc). I then tried the same import myself, logged onto the same workstation with my own Recorder Login, no joy, same error. Next I logged her out of windows, logged myself in, logged myself into Recorder, tried again, still no joy. Finally I returned to my own workstation, logged myself in and did the import with no difficulty.

Now I could do all the imports myself, but it's not my main job and I have a million other things to do rather than watching  Recorder process the hundreds of thousands of records which we still have to import.

The only difference between myself and the other member of staff is the level of access permission to the folder where the NBNData files are stored. Normal operation of Recorder 6 does not require full access to this folder,  but apparently the import wizard does. I have consulted our ITC man and he is not prepared to grant modify access to the folder for all staff who will use Recorder, since it also contains a number of other very important databases, to which we should not have access.

What is the solution to this problem? Logically it would seem best to remove the NBNdata files to another folder, to which we can grant access, but we don't know how to go about this without breaking recorder.

Any suggestions?

The full error text is

date/time         : 2009-03-03, 15:48:02, 417ms
computer name     : BRC250507
user name         : Purglel
operating system  : Windows XP Service Pack 3 build 2600
system language   : English
system up time    : 6 hours 17 minutes
program up time   : 5 hours 33 minutes
processors        : 2x Intel(R) Pentium(R) D CPU 3.00GHz
physical memory   : 449/999 MB (free/total)
free disk space   : (C:) 52.27 GB
display mode      : 1280x1024, 32 bit
process id        : $c7c
allocated memory  : 22.85 MB
command line      : RecorderApp.exe /1180660
executable        : RecorderApp.exe
exec. date/time   : 2008-11-04 08:45
version           : 6.13.3.182
madExcept version : 2.7h
exception class   : EInOutError
exception message : File access denied.

main thread ($67c):
00701df3 RecorderApp.exe DBMerger        947 TDBMerger.WriteToLog
006fe5ca RecorderApp.exe DBMerger        239 TDBMerger.DoMerge
007080dc RecorderApp.exe TempData_ADO   1332 TTempData.CopyRecordsIntoMainDB
009006f3 RecorderApp.exe ImportAnalysis  759 TfraImportAnalysis.SaveContent
008fd1e5 RecorderApp.exe ImportWizard    176 TfrmImportWizard.btnNextClick
004b4048 RecorderApp.exe Controls            TControl.Click
004a9160 RecorderApp.exe StdCtrls            TButton.Click
0046ff09 RecorderApp.exe Buttons             TBitBtn.Click
004a9254 RecorderApp.exe StdCtrls            TButton.CNCommand
004b3eb0 RecorderApp.exe Controls            TControl.WndProc
004b6f0f RecorderApp.exe Controls            TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls            TButtonControl.WndProc
006f42d4 RecorderApp.exe XPMenu         2928 TControlSubClass.ControlSubClass
7c90eb74 ntdll.dll                           RtlAnsiStringToUnicodeString
004b3c80 RecorderApp.exe Controls            TControl.Perform
004b7047 RecorderApp.exe Controls            DoControlMsg
004b769f RecorderApp.exe Controls            TWinControl.WMCommand
004b3eb0 RecorderApp.exe Controls            TControl.WndProc
004b6f0f RecorderApp.exe Controls            TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls            TButtonControl.WndProc
00445985 RecorderApp.exe Classes             TList.Delete
004b6b8c RecorderApp.exe Controls            TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes             StdWndProc
7e4292de user32.dll                          SendMessageW
7e42a993 user32.dll                          CallWindowProcA
004b6ff3 RecorderApp.exe Controls            TWinControl.DefaultHandler
004b4450 RecorderApp.exe Controls            TControl.WMLButtonUp
004b3eb0 RecorderApp.exe Controls            TControl.WndProc
004b6e41 RecorderApp.exe Controls            TWinControl.WndProc
004a9024 RecorderApp.exe StdCtrls            TButtonControl.WndProc
006f42d4 RecorderApp.exe XPMenu         2928 TControlSubClass.ControlSubClass
004b3c80 RecorderApp.exe Controls            TControl.Perform
004b6b8c RecorderApp.exe Controls            TWinControl.MainWndProc
004528d8 RecorderApp.exe Classes             StdWndProc
7e4196c2 user32.dll                          DispatchMessageA
004d4de3 RecorderApp.exe Forms               TApplication.ProcessMessage
004d4e1a RecorderApp.exe Forms               TApplication.HandleMessage
004d503a RecorderApp.exe Forms               TApplication.Run
0099f832 RecorderApp.exe RecorderApp     317 initialization