| re: oracle backend connection
"SalimShahzad" <salimshahzad@gmail.com> wrote in message
news:1111923689.463104.297280@g14g2000cwa.googlegr oups.com...[color=blue]
> dear gurus,
>
> i have converted database from access to oracle due to lack of capacity
> soring limits in access.
>
> now i can see all tables of oracle via using ms access front end, using
> ODBC connection very easy.
>
> but the issue is that, on every time whenever i open any forms of
> access, it ask me database password, however userid,dbname,dsn name is
> gtg from odbc connection. there is no option to save password
>
> so can any one tell me how it can be done via programming on opening
> forms and populate ms access fields or say form is connected directly
> to oracle.but again it asks one time password that is very bed 4 us and
> our staff to show them this secret truickyway
>
> ur students,
> salim shahzad
>[/color]
You will need to modify the connection string to include the UserID and
Password. For example:
....DSN=MyDSN;UID=MyUserID;PWD=MyPassWord;...
| 
