Help - quering and other?

J

James C.

My question is twofold:
I tried to run a query on a table generated by query (for this message, I
will call this first table the original). Access warned me that 'i will
modify the present table and would i like to continue?'. I clicked no and
instead copied the table and pasted (and renamed) the table into the current
database. I tried to run the query on this table. Instead, I got error
message stating that the query1 failed. So I undid the copy. When I tried to
open the original table, it contained no records and the table possessed no
link to anything. So here are the questions:

a) How do I repair the damage I invertly did to the original database? [this
is the most of the two questions. I am in a lot of hot water if I do not get
this fixed]
b) What is the 'right' way to run a query so as to generated a new table and
not modify the original?

Im using Access 2002 on windows 2000
 
T

Tom Wickerath

Hi James,

a) Restore from a back-up copy of your database, which you hopefully have
available.

b) Use a Make-Table query. Start by creating a normal SELECT query. Once you
have the criteria set correctly, so that it is returning the desired records,
then click on Query > Make-Table Query... in query design view.

You should examine your need for running Make-Table queries. If this is
something that you plan on doing on a regular basis, be aware that it can
lead to database bloat.

Tom
________________________________________

:

My question is twofold:
I tried to run a query on a table generated by query (for this message, I
will call this first table the original). Access warned me that 'i will
modify the present table and would i like to continue?'. I clicked no and
instead copied the table and pasted (and renamed) the table into the current
database. I tried to run the query on this table. Instead, I got error
message stating that the query1 failed. So I undid the copy. When I tried to
open the original table, it contained no records and the table possessed no
link to anything. So here are the questions:

a) How do I repair the damage I invertly did to the original database? [this
is the most of the two questions. I am in a lot of hot water if I do not get
this fixed]
b) What is the 'right' way to run a query so as to generated a new table and
not modify the original?

Im using Access 2002 on windows 2000
 
Top