Lonnie Johnson
prodevmg at yahoo.com
Tue Feb 1 15:54:33 CST 2005
Look up pass through queries in Access Help. There you can store the passord and uid in the connection string and send you sql via the pass through query "Kaup, Chester A" <kaupca at chevrontexaco.com> wrote:Is it possible to write an access query to update an oracle table that requires a userid and password to get to the oracle DB? I can connect to the oracle table with ODBC but then what? Chester Kaup Information Management Technician IT-MidContinent/MidContinent Business Unit CTN 8-687-7415 Outside 432-687-7415 No trees were killed in the sending of this message. However a large number of electrons were terribly inconvenienced. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us --------------------------------- Do you Yahoo!? Yahoo! Search presents - Jib Jab's 'Second Term'