Re: Make table query, how does it get to back end database
- From: "Allen Browne" <AllenBrowne@xxxxxxxxxxxxxx>
- Date: Tue, 28 Nov 2006 23:32:12 +0800
Open the query in design view.
Choose Make Table on the Query menu.
That should cause Access to pop up a dialog asking the name of the table to
make. The dialog also gives the option for "Another database." You can
choose the back end mdb.
Personally, I never Make Table in a real database. My preference is to
create the table with the fields exactly as they should be, indexes and
primary key defined, and properties set for the fields. Then use an Append
query to add the data, and a Delete query to clear the data out.
Regarding whether the table should be in the FE or the BE, consider what
this temporary table is for. For example, if it is for a report, and it is
possible that multiple users could be running this report at the same time,
it needs to be in the FE to prevent them from interfering with each other.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.
"Tina" <Tina@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:63B5DCFE-9D9C-42F5-A0CE-6E7CCD12ACBF@xxxxxxxxxxxxxxxx
I split a database and now have a front end and back end. Everytime we run
a
make table query, the table is created in the front end, how can we run
the
query to create the table in the back end. Or do we physically move the
table to the back end create a link to it? Creating the table in the
front
end makes the front end very big.
--
Tina
.
- Prev by Date: Re: Error: Specified field could refer to more than one table
- Next by Date: Re: dropping a relationship (i.e. constraint?)
- Previous by thread: Re: Error: Specified field could refer to more than one table
- Next by thread: Re: dropping a relationship (i.e. constraint?)
- Index(es):
Relevant Pages
|
