Queries Links Change

[Guest]

I have a general question on Access 2003. I have several applications that
run in the following manner:
Step 1: Make Table queries runs and creates some large tables (extracting
data out of ORACLE, etc.).
Step 2: several other queries run for summing totals, etc. using tables from
step 1
Step 3: Import process deletes tables from step 1 to clean up space in the
database.

The problem I seem to run into is that if someone goes into the queries from
step 2 in design view when the tables are NOT existing in the database, the
links and tables are not there and queries get saved with no links.

I do not remember this happening in previous versions of Access. Is there a
setting somewhere to change this or any way to prevent it from happening? Or
does this only happen when somehow the SETWARNINGS feature got set to FALSE?
Even when tables are re-created from step 1, if you go into queries in step
2, the links are missing.

Any thoughts would be GREATLY appreciated!
Thanks!

 

[Guest]

Luke,

The way I usually handle this is to create the temporary tables as permanent
tables. I never actually delete them, only the contents of them.
Additionally, I don't actually put these tables in my application database, I
put them in an mdb that I call something like myApp_TempTables.mdb. I then
link these tables to my application so that they don't bloat my application,
but can be used just like they were resident in my applicaiont database.

The advantage to this technique is that the queries that use these tables
are always present in the database, so you can edit the query even when there
is no data in the tables.

HTH
Dale

 

[Aaron Kempf]

I think that the idea of havnig THREE TIERS of MDB files is just ridiculous

I mean seriously-- where do you get off STFU kid

move to Access Data Projects, and SQL Server

temp tables are automagically created in a TempDB databse -- all you need to
do with ADP is use # before the table name and it is a temp table

it works like a charm, it cleans up after itself

and it doesn't require 200 different MDB files

 

[Aaron Kempf]

move to ADP

and keep everything in a real database

Oracle is a scam