Coldfusion Can't Find Table

[marcnz]

I have been charged of creating a coldfusion web site for our company.
Our database has a ms sql 2005 backend and ms access frontend. Almost all tables are linked tables with the SQL database, except the temp tables needed at runtime that are in the ms access database.
It will be easier for us to utilize the ms access queries and temp tables, so I set up a datasource on our web server and within the coldfusion administrator to point to the ms access database witht he ms access .mdb driver.
The datasource comes as OK in the coldfusion datasource page.
When I try to run a query from my coldfusion page, the requested table can't be found, although it is there.
The original name of the table is dbo.myTable, but we renamed all the tables in access to remove the "dbo." part, so it shows up as "myTable" only: error message:

"Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] The Microsoft Jet database engine cannot find the input table or query 'Calmweb_Custom er'. Make sure it exists and that its name is spelled correctly.

The error occurred in D:\websites\www \Calmweb\forceU serLogin.cfm: line 26
Called from D:\websites\www \Calmweb\Applic ation.cfc: line 18
Called from D:\websites\www \Calmweb\forceU serLogin.cfm: line 26
Called from D:\websites\www \Calmweb\Applic ation.cfc: line 18

24 : FROM Calmweb_Custome r
25 : WHERE Username = '#FORM.userLogi n#'
26 : AND Password = '#FORM.userPass word#'
27 : </cfquery>
28 :"

The table Calmweb_Custome r actually exists and has records.

I tried to put in my query the full dbo.myTable, but coldfusion comes up with the error it can't find the table "dbo"... here is the error message:

"Error Executing Database Query.
[Macromedia][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access Driver] Could not find file 'C:\CFusionMX7\ db\slserver54\l ogging\dbo.mdb' .

The error occurred in D:\websites\www \Calmweb\forceU serLogin.cfm: line 26
Called from D:\websites\www \Calmweb\Applic ation.cfc: line 18
Called from D:\websites\www \Calmweb\forceU serLogin.cfm: line 26
Called from D:\websites\www \Calmweb\Applic ation.cfc: line 18

24 : FROM dbo.Calmweb_Cus tomer
25 : WHERE Username = '#FORM.userLogi n#'
26 : AND Password = '#FORM.userPass word#'
27 : </cfquery>
28 :"

If anyone has any idea, that would be great.
Thanks a lot.

[ConanTheVegetarian]

Could be a permissons issue. Check the datasource has correct read permissions on the table.

(BTW, I'm assuming the lack of <cfqueryparam > tags around the variables in the query is just for sake of brevity).