Client Access ODBC logon information

[lalato]

Our database is accessed via the Client Access ODBC driver. Every time I open up a report created by someone else, it retains that person's User ID at the prompt. Does anyone know how to force Crystal Reports to use the machine's User ID, instead of the report creator's User ID?

Thanks for the help,
--sam

 

[kanau]

Hi, Sam

Configure the System DSN of Client Access, in the General Tab, click "Connection Options" and select "Use Windows user ID ...."

Hope this can solve your problem !

Kan

 

[lalato]

We've been using the option the option where you specify the UserID. I'll give the Windows logon option a try and let you know if it makes a difference.

--sam

 

[dataprincess]

Out of curiosity what database are you accessing?

 

[lalato]

We access a proprietary database for newspaper distribution.

--sam