oracle backend connection

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

"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;...

> i have converted database from access to oracle due to lack of capacity[color=blue]
> soring limits in access.[/color]

On what platform are you running Oracle? Windows? Linux? Solaris?