Re: Queries Links Change

move to ADP

and keep everything in a real database

Oracle is a scam


"Luke Bailey" <LukeBailey@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:33A9469B-E2E3-4FC7-8B77-A23633A27D6A@xxxxxxxxxxxxxxxx
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!




.

Relevant Pages

  • Re: SQL Injection
    ... > I am currently pen-testing a web app and I am stuck in trying to execute ... two queries sequentially in Oracle. ... You won't have luck with this in Oracle. ... the end query build by a cgi-script being ...
    (Pen-Test)
  • Re: ORACLE CLIENT USERS BEWARE: Bug in Query Builder breaks SQL
    ... Can you enlighten me; you appear to be saying there are three different ways to run queries against Oracle; ... If you have to move projects from VS2003 that include such SQL queries, you have to fix it all by hand. ... When trying to use the Query Builder with Oracle, queries that create INNER JOIN syntax result in an error in Query Builder when trying to generate your schemas. ...
    (microsoft.public.vsnet.general)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Re: SELECT DISTINCT slow, how can I speed up
    ... We have staff using Access 2003 as a front end to the Oracle tables ... for the purposes of ad hoc queries. ... come back within a second of the SQL starting to run. ... only 20-50 rows come back and the query takes 28 seconds and there is ...
    (comp.databases.oracle.server)
  • Oracle --> SQL DTS issue
    ... I am accessing a Oracle Database for DTS using MS ODBC driver. ... The simple queries can easily provide the data required over the DTS, ... I really wish to avoid getting major chunks of data over to the SQL ...
    (microsoft.public.sqlserver.dts)