|
Hi,
I am trying to get some tables from the oracle 10g database that I have on my machine into an access database. I used the Get External Data option in access and followed the steps in this tutorial:
http://aspalliance.com/893_Creating_an_MS_Access_2003_Front_End_for_an_Or acle_10g_Express_Edition_Database.2
For example, I tried getting the Employees and Departments tables from the hr schema. I was able to link them successfully, however when I click on them to view the data, the employees table produce the following error:
Could not execute query; could not find linked table [Microsoft][ODBC driver for Oracle][Oracle]ORA-00942: table or view does not exist (#942)
Microsoft Office Access can't open the table in datasheet view.
I deleted the data source created, gone through the same process and it worked fine. Now I am having the same problem with other tables.
What I mean is that it sometimes work fine other times it gives the error above.
I am using Access 2003 and Oracle 10g.
Please Help ..
Thanks
| 
