Make table query, how does it get to back end database

[Guest]

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.

 

[Allen Browne]

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.

 

[Guest]

Thanks, this really helped.
--
Tina

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.