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
