Linking tables without knowing UNC path

[Guest]

I have a split database that utilizes make table queries. I won't know the
UNC paths for all the users that will be using this database, so I have the
make table queries create the new table in the current database instead of
specifing the back end. All of these tables get deleted prior to being
recreated by the query anyways by a macro. Should I just leave those tables
in the front end?

 

[Guest]

Yes.

Also each user should have their own FE. Lets say that I'm going to run a
report based on one of these temp tables. I click the button that creates the
table then produces the report. However about 2 seconds later someone else
wants to run a similar report that uses the same temp table. Depending on
certain settings, someone might not be too happy.

If you do have to use temp tables, the best place is in the FE. Of course
not using temp tables at all is usually the best solution.

 

[Guest]

Thanks for answering my question. I did end up leaving the temp tables in
the front end. I don't know how to avoid them at all, so I just set up the
macro so that instead of deleting them before running the make table query,
it deletes them after they have served their purpose so that they don't stay
in the front end.

 

[Guest]

I recommend never using make table queries. The are slow and inefficient.
There may also be problems with correct data types when importing from
external sources. The better technique is to create the tables with the
proper field lengths and data types. The just delete all the data from them
when you are done with them.

 

[John Spencer]

Let me jump in here with yet another scenario.

If you need to create the temp tables, it is often a better solution to
create a temp database and then create the tables in the temp database and
link to the tables. This eliminates a lot of the database bloat that occurs
with adding and deleting records.

See Tony Toews website
http://www.granite.ab.ca/access/temptables.htm
for an example

--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..