Prev: Autocomplete Employee info
Next: Duplicate showing in query when there shouldn't be
From: Carl_B on 16 Mar 2010 12:36
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
From: Jeff Boyce on 16 Mar 2010 17:23
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" <CarlB(a)discussions.microsoft.com> wrote in message
news:E4E3F89E-DD15-4FBD-A5CC-7C460E07EF9E(a)microsoft.com...
> 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


From: Carl_B on 17 Mar 2010 08:30
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" wrote:

> 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" <CarlB(a)discussions.microsoft.com> wrote in message
> news:E4E3F89E-DD15-4FBD-A5CC-7C460E07EF9E(a)microsoft.com...
> > 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
>
>
> .
>
From: Jeff Boyce on 18 Mar 2010 12:05
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.

"Carl_B" <CarlB(a)discussions.microsoft.com> wrote in message
news:2CD2C531-B9B5-4541-8A33-72F09EA62B79(a)microsoft.com...
>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" wrote:
>
>> 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" <CarlB(a)discussions.microsoft.com> wrote in message
>> news:E4E3F89E-DD15-4FBD-A5CC-7C460E07EF9E(a)microsoft.com...
>> > 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
>>
>>
>> .
>>


 | 
Pages: 1
Prev: Autocomplete Employee info
Next: Duplicate showing in query when there shouldn't be