runtime error 3151

[Kalyan Ganesan]

I have a accdb, everything in it was working fine,it has linked tables that are linked to Oracle (11g) and configured thru odbc,after the long weekend the system was restarted and i keep getting this error since yday

runtime error 3151 when i open a form that connects to the database thru odbc,also get this error when i open a linked table..

what to do?i checked the odbc connection in administrative tools data sources and it works fine

 

[dhookom]

Have you attempted to relink the tables?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[Kalyan Ganesan]

Oh yes,so many times,no use

 

[dhookom]

Have you attempted to create a pass-through query to the Oracle table?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[Kalyan Ganesan]

well the problem is its not letting me to connect thru ODBC at all,so there is no way i could create the pass through query,and like i said it connects fine in ODBC thru control panel but not from ACCESS..that too only since last two days...

 

[dhookom]

Have you tried through Excel to determine if this is an Access issue or something else?

Duane
Vevey, Switzerland
Hook'D on Access
MS Access MVP 2001-2016

 

[Kalyan Ganesan]

I tried and i am getting this error picture attachedLink