I have written a program that draws some base data from an MS SQL database via ODBC which I can then manipulate.
The program I have written works fine.
However, I have struck an interesting problem when I share the file and attempt to use it from another device.
The other device can open the program but at soon as it attempts to run a script that draws on the ODBC link a message pops up "The account you entered cannot be used to access file. Please try again." and I am unable to access layout displaying data from the ODBC source.
This program has been written to be shared, ultimately on a server, but initially in the acceptance and setup phase it will be shared peer-to-peer.
Is someone able to explain what might be happening and any solution path around the problem.
All and any help much appreciated.