(Msg. 1) Posted: Mon Jun 08, 2009 6:20 am
Post subject: Make Table Query Archived from groups: microsoft>public>access (more info?)
Novice to Microsoft Access.
How can you tell what Table is created from a Microsoft Access make Table
Query?
I've inherited this Microsoft Access Database with all these make Table
Queries and I've been digging around to see what tables are created by them
and can't seem to find that answer.
(Msg. 2) Posted: Mon Jun 08, 2009 9:33 am
Post subject: Re: Make Table Query [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
PSULionRP,
In your SQL statements, the INTO of a Make-Table query would indicate
the make table's name.
or
In query design mode, select View - SQL View to see the SQL statement.
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html
"Find a job that you love... and you'll never work a day in your life."
"PSULionRP" <PSULionRP.RemoveThis@discussions.microsoft.com> wrote in message
news:EF87964A-DA80-4077-8B5B-17C8E04E12D2@microsoft.com...
> Novice to Microsoft Access.
>
> How can you tell what Table is created from a Microsoft Access make Table
> Query?
>
> I've inherited this Microsoft Access Database with all these make Table
> Queries and I've been digging around to see what tables are created by
> them
> and can't seem to find that answer.
>
> Thanks in advance for your review and help.
>
> PSULionRP
>
>
(Msg. 3) Posted: Mon Jun 08, 2009 9:58 am
Post subject: Re: Make Table Query [Login to view extended thread Info.] Archived from groups: per prev. post (more info?)
On Mon, 8 Jun 2009 06:20:01 -0700, PSULionRP
<PSULionRP.DeleteThis@discussions.microsoft.com> wrote:
>Novice to Microsoft Access.
>
>How can you tell what Table is created from a Microsoft Access make Table
>Query?
>
>I've inherited this Microsoft Access Database with all these make Table
>Queries and I've been digging around to see what tables are created by them
>and can't seem to find that answer.
>
>Thanks in advance for your review and help.
>
>PSULionRP
>
I hope you're asking in order to figure out how to get RID of all these
make-table queries. Such queries will be very rare indeed in a properly
designed production database!
All times are: Eastern Time (US & Canada) (change)
Page 1 of 1
You can post new topics in this forum You can reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
Home
Forums
Home
FAQ
Profile
Private Messages
Log in
Office Other