Hey neil,The message indicates that on the system from where you start the console is no Microsoft Office 2010 neither Microsoft Access Database Engine 2010 Redistributable installed. Have you already rebooted the machine after installation?If x64 operating system is used:Start the 32 bit service desk console and check if the message still apprears. This can be caused by x64 os with 32bit office installations.
I have now made sure that the Office installation on the server is 64bit Office and the Access Database engine 64bit is installed. which allowed me to set up the initial data connection but when i try and set up a new connection Type I get the following message
The Microsoft Access database engine cannot open or write to the file c:// It is already open exclusivley by another user, or you need permissions to view and write this data.
The file is not open and all the permissions seem fine so I cannot understand why I cannot set this up.
Your TPS is likely running under an account that doesn't have access rights to that directory. Check the application pool in IIS and there is a property called Application Pool Identity. Set this to be NETWORK SERVICE or a service account then grant modify access to the folder in question to that user.
Hope this helps.