>>
>>Assumptions:
>>
>>database=MyData
>>connection=conOracle
>>vueOracleTable = remote view from Oracle database
>>cUser = memory variable containing User ID
>>cPW = memory variable containing Password
>>
>>
>>
>>OPEN DATABASE MyData
>>=DBSETPROP(conOracle,"CONNECTION","UserID",cUser)
>>=DBSETPROP(conOracle,"CONNECTION","PassWord",cPW)
>>USE vueOracleTable
>
>John,
>
>The only problem with your solution is that it makes a persistent change in the database. If multiple processes are using the same connection it's possible to run into a problem.
>
>I've seen two solutions:
>
>The first is where each workstation has a local database that contains all the connections and views. Then using DBSETPROP() to adjust the connection username and password would work fine, unless your running multiple instances of the app on the same workstation.
>
>The second is to have the application log into the server using a single login.
>
>This is a major problem, IMO!
Yeah you're right...I was just stymied. Another solution is to modify the ODBC at each user computer to automatically pass the userid and password but that seems to be a breach of security.
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05