Hi I am trying out multi file solutions first time ..
One file A which has been authorized to access file B to lookup data in a table in file B
Users in file A are being prompted for a password each time ..
Can i somehow give permanent access to the file A so that users in file A need not enter credentials for file B ?
Or Do i have maitain same user accounts in both files ?