Access 2007 linked to Oracle

[Carl_B]

We have an access front end that was just upgraded to Access 2007 from Access
2003. Some of the table are linked to an Oracle backend and also has local
tables, created in the previous versions of Access.
None of the tables are displaying a datasheet when an attempt to open them
is made and nothing happens when a query is run.
Any suggestions as to what to look for to correct this issue will be
appreciated.
Thank you
Carl

 

[Jeff Boyce]

Carl

If you can't open the tables and you can't query against them, how do you
know they are there?

(do you have a backup?!)

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.

 

[Carl_B]

I can see the Icon that represents the Oracle tables, and have updated the
links, successfully. Thus, I assume they are there.
But double clicking a table produces no data and the queries likewise do not
display a datasheet.

 

[Jeff Boyce]

OK, if you've refreshed the links, and you can see that you are linked,
maybe Oracle isn't allowing you to see the data. Can you confirm that you
have permissions on the server-side?

--

Regards

Jeff Boyce
Microsoft Access MVP

Disclaimer: This author may have received products and services mentioned in
this post. Mention and/or description of a product or service herein does
not constitute endorsement thereof.

Any code or pseudocode included in this post is offered "as is", with no
guarantee as to suitability.

You can thank the FTC of the USA for making this disclaimer
possible/necessary.