Re: Ora-01017 when using Access2002 as Front instead of Access2000

From: <treschaud33_at_yahoo.com>
Date: 27 Apr 2007 11:55:00 -0700
Message-ID: <1177700100.222079.309320@o40g2000prh.googlegroups.com>

> When the query was put on an Access2002 machine, it came up with
> "ORA-01017 invalid logon/password", and fails. The failing machine
> passes other queries and operations with the same Oracle database
> without problem.
>
> Any help is appreciated.

I assume you are using linked tables. Have you refreshed the tables using the linked table manager? Tools | Database Utilities | Linked Table Manager. If you have it prompt for a new location I believe you can re-enter the password.

What happens if you create a new linked table to the Oracle DB table. Does that work? Received on Fri Apr 27 2007 - 13:55:00 CDT