Access report Error 731

[subashkr]

hi
I have ove report module ADP file connected to SQL 2000 server. Its working fine in a profile (what ever it is) installed in a windows 2000 server machine . But whenever i try from a different profile its not working its giving error 731 . Please help me out. I want to share this program through a Citrix farm also.

Thanks
Subash

 

[cmmrfrds]

If it works on one profile it is probably a permissions problem. How do you have the permissions set up on the sql server tables. Is it by NT Authentication? Each profile has a login ID, check the ID against the login ID you have set up for the sql server table(s).