Powerprompts ->> rs.Open() Method

[Prasad678]

Hi All,
In powerprompts we use rs.open(QRY,UId,pwd,DBName) to open a recordset.

If the application is moved to production & if we have to change the Database username & pwd, we change that manually by opening the powerprompt code.

Is there any way in which AccessManager can be linked here to solve this problem sothat change of username & pwd in one place will reflect in all the places??

Thanx,
Prasad.

 

[viRtuAlinsaniTy]

Hi Prasad,

Can you tell me what the parameters are for rs.open in powerprompts?

if I use them in the same order that you list them then it tells me the Uid is not a valid DB. I asm connecting to SQL & I just want to know where to put the UID & Pwd.

Thanks,

Hamish.