Prev: Access 2007 Append Query – Issue with automatically inserted b
Next: SQL server backend
From: Kathy R. on 19 May 2010 09:43
Is your query in a front-end and the table in a back-end? If so, make
sure they're linked correctly. I recently tried creating a query and
couldn't find see the tables after I had added them. Didn't receive any
kind of error message or anything; scrolled all over the place and still
couldn't find them. I finally realized I hadn't re-linked my tables.

Kathy R.

DontKnow wrote:
> Hi John,
>
> I tried again with:
> 1. taking a copy of the SQL from the original query with the rogue table not
> able to be seen on the QBE
> 2. copying the sql from 1 into a new query and it worked no problems, with
> all tables able to be seen!! (without having to compacted)
>
> many thanks for your assistance
>
> cheers, Access 2003 by the way
>
>
>
> "John W. Vinson" wrote:
>
>> On Tue, 18 May 2010 19:25:01 -0700, DontKnow
>> <DontKnow(a)discussions.microsoft.com> wrote:
>>
>>> Hi John,
>>> Thnaks for your input...
>>> I tried both of your suggestions and neither worked!
>> WHAT???
>>
>> You copied the (text only, no image information) SQL out.
>>
>> Deleted the query.
>>
>> Compacted the database.
>>
>> Recreated the query by copying the SQL into the SQL window of a new query.
>>
>> And it put the image back offscreen!???
>>
>> What Access version?
>> --
>>
>> John W. Vinson [MVP]
>> .
>>
From: DontKnow on 19 May 2010 19:03
Hi Kathy,

No the tables have not been split... and they defintely were linked
correctly.

Unfortunately for me one of the tables could not be seen. The only way that
I could see them, was as John pointed out was to copy the SQL into a new
query and switch to design view. Then the all tables were able to be seen...
Just doesn't figure does it!!

cheers,

many thanks for your input though,
"Kathy R." wrote:

> Is your query in a front-end and the table in a back-end? If so, make
> sure they're linked correctly. I recently tried creating a query and
> couldn't find see the tables after I had added them. Didn't receive any
> kind of error message or anything; scrolled all over the place and still
> couldn't find them. I finally realized I hadn't re-linked my tables.
>
> Kathy R.
>
> DontKnow wrote:
> > Hi John,
> >
> > I tried again with:
> > 1. taking a copy of the SQL from the original query with the rogue table not
> > able to be seen on the QBE
> > 2. copying the sql from 1 into a new query and it worked no problems, with
> > all tables able to be seen!! (without having to compacted)
> >
> > many thanks for your assistance
> >
> > cheers, Access 2003 by the way
> >
> >
> >
> > "John W. Vinson" wrote:
> >
> >> On Tue, 18 May 2010 19:25:01 -0700, DontKnow
> >> <DontKnow(a)discussions.microsoft.com> wrote:
> >>
> >>> Hi John,
> >>> Thnaks for your input...
> >>> I tried both of your suggestions and neither worked!
> >> WHAT???
> >>
> >> You copied the (text only, no image information) SQL out.
> >>
> >> Deleted the query.
> >>
> >> Compacted the database.
> >>
> >> Recreated the query by copying the SQL into the SQL window of a new query.
> >>
> >> And it put the image back offscreen!???
> >>
> >> What Access version?
> >> --
> >>
> >> John W. Vinson [MVP]
> >> .
> >>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: Access 2007 Append Query – Issue with automatically inserted b
Next: SQL server backend