Insert Record into Oracle Table

[gaugust]

In Access 2003 running under XP Pro I would like to update an Oracle table
within my Access application, but I am always prompted for the password.
Within Oracle I used local naming (using the Oracle Net Manager) to create a
connection to the Oracle database. I then created a system DSN for the
Oracle database using the Oracle driver in Access. The driver does not ask
for a password unlike the driver for Access or SQL Server. I created the
following SQL statement to insert a record, but everytime the SQL runs I get
prompted for the Oracle database password. Can the password be set in the SQL
string so that I won't be prompted? If not, where can the password be set?
Thanks

DoCmd.SetWarnings WarningsOff
lstrSQL = "INSERT INTO ICU_ICU_LINES (ID, MRN, LINE, TIME_STAMP,
DAY, UPDATE_TIME) "
lstrSQL = lstrSQL & "VALUES ('" & Me.Text188 & "','" & Me.MRN
lstrSQL = lstrSQL & "','" & Me.Text188 & "','" & Me.TimeVal
lstrSQL = lstrSQL & "','0','" & Now() & "')"
DoCmd.RunSQL lstrSQL
DoCmd.SetWarnings WarningsOn

 

[gaugust]

I discovered that there is a check box when you link to the Oracle table in
Access to save the password.