crystal123456
Programmer
I am trying to use an Excel table as an ODBC connection but I am having trouble adding the datasource in Crystal and I am getting an error saying "Logon Failed, Details: HY000 The Microsoft Jet database enginer cannot open the file '(unknown)'. It is already opened exclusively by another user, or you need permission to view its data"
I will explain more as to how everything is currently set up
1) We have a client computer on our network that the file is stored on. This file is always opened on this computer as it is used to collect data from another program. I have added a named range within this file that contains the data that I am looking to pull into Crystal. The version of Excel on this client computer is Excel 2010
2) I am trying to access the data and write a crystal report on my own computer which has Excel 2003. I have gone into the ODBC connections of my computer and tried to add the named range as a connection and that is where I am getting the above error message.
Is there another way I should be going about this to make this work properly?
Any help is greatly appreciated!
Thank you
I will explain more as to how everything is currently set up
1) We have a client computer on our network that the file is stored on. This file is always opened on this computer as it is used to collect data from another program. I have added a named range within this file that contains the data that I am looking to pull into Crystal. The version of Excel on this client computer is Excel 2010
2) I am trying to access the data and write a crystal report on my own computer which has Excel 2003. I have gone into the ODBC connections of my computer and tried to add the named range as a connection and that is where I am getting the above error message.
Is there another way I should be going about this to make this work properly?
Any help is greatly appreciated!
Thank you