Access 2010 Tricks: Ghost Tables

[RLS]

I am working on upgrading a client from CF5 to CF10 as well as Access 2010 to SQL Server Express 2012.

I suspect they recently moved from Access 2000 to 2010 based on some message I came across. Don't know if that is germaine to this conversation or not, so I thought I'd throw that in.

In the new CF10 environment, I had a query fail. At first glance, it appeared that one table didn't come across in the conversion.

Checked my copy of the Access database backup -- that table is not there.

Tested the production (CF5 running Access) system and this program works.

Looked in the production Access database -- and the table is NOT there, either!

What is this magic?  I see no stored procedures, and it's not a cursor (CF5 didn't have that capability).

Here's the query:

<cfquery name="get_job" datasource="sts">

  SELECT          *

  FROM                    validate_jobnumber

</cfquery>

How is it possible to query an Access table that doesn't exist?  Where should I look for this mythical creature?

RLS

[RLS · Accepted solution]

Never mind, figured it out.  The copy I had did not have the queries in it. There were a number of custom queries in the Access database. RLS