report cannot find database

[icca]

Hi,
i have this report that uses three different databases, two sql-server and one access.. everything works fine when you are logged on to the network as administrator.

but when you change user you can't open the reports. i have tried to set the user ID and password in code but it makes no diffrence. it still prompts for location and id and does not find it even tho i type in the correct stuff. It only says 'login failed'.

any thoughts on why this happens?
/icca

 

[synapsevampire]

Sounds like permissions.

Your assesment that it can't find the report and the error conflict, it sounds like it finds and opens the report, it just can't open one or more of the data sources.

-k

 

[icca]

yes, i did some thinking and came to the same conclusion.. it was the permissions on the sql-server that caused the problem.

/icca