Database access error. Please help!

[Grynch]

I finially manages to get my Access database to connect with Coldfusion,
however when i run a simple 'Select * from [table]' statement, i get this error.

[MERANT][SequeLink JDBC Driver][ODBC Socket][Microsoft][ODBC Microsoft Access
Driver] The Microsoft Jet database engine could not find the object
'TAB_SECURE'. Make sure the object exists and that you spell its name and the
path name correctly.

The Error Occurred in F:\CFusionMX\wwwroot\BaccSys_source\TopBanner.cfm: line
58

55: <cfquery name="getTabs" datasource="access">
56 : select *
57 : from TAB_MENU
58 : </cfquery>
59 :
60 : <cfoutput query="getTabs">#getTabs.tab_text#</cfoutput>

the object that it can't 'find' always seems to be the last column in the
table.

Does anyone know how i can fix this. Any help apperiected!

Thanks!

[vkunirs]

Hi

you are saying that it could find the last column in the table but as you
have in that there is word 'TAB_SECURE'.

can you confirm that you are getting connected to that MS-Access table and
try display the table records count.
then later try display if it is k.

[Grynch]

Hi

It must be connected to the database ok, because it is displaying the error
about a column name in a table. It also says that the connection is 'ok' when i
verify it using coldfusion administrator.

Any other ideas what could be causing this?

Thanks.

[Knum]

Is your datasource name correct? Access is a little strange for a DSN

[Grynch]

Knum,

do you mean inside the cfquery tag?

If so, yes, it's is correct.

I have also tried renaming the DSN (does that mean datasource name by the way?!) but i still get the same error.

[vkunirs]

Hi

when we write the query as "select * from table"...it has to give all the
fields which are there in the table.
i am not understanding why you are getting this error.
even though your retreving all the fields.

now try to give the other table name then try it, with the same DSN.

[ranger]

just a dumb ? but is your database named 'access'? could cause a conflict... if not, the datasource is the name of the database as registered in cf admin and ODBC.