[jojsh45]

I am using an Access Database backend and Excel Frontend for some queries. One particular query executes OK in MS Access, but when refreshing the same query in MS Excel, gives the error "The Microsoft database Jet Engine cannot find the table or query "Year". The table "Year" is available and Excel can acces it as a serparate query.

Make sure it exists and its name is spelt correctly." The system has recently been upgraded with new hardware, and has moved from MS Office 2000 to MS Office 2003. Needless to say, it used to work on the old computer!

Any ideas?

[Advertisements]

Without seeing all your code it is difficult to say why you are experiencing this problem.

You may want to try renaming your table to "tblYear" and edit your queries accordingly.

There is lots of room for misinterpretation particularly with a string like year which is an inbuilt function.

My experience is less room for error when you follow a naming convention and prefix your objects with standard strings eg. tbl qry frm rpt mac mod etc...

and it makes debugging easier later


DSM

[dsm]

Without seeing all your code it is difficult to say why you are experiencing this problem.

You may want to try renaming your table to "tblYear" and edit your queries accordingly.

There is lots of room for misinterpretation particularly with a string like year which is an inbuilt function.

My experience is less room for error when you follow a naming convention and prefix your objects with standard strings eg. tbl qry frm rpt mac mod etc...

and it makes debugging easier later


DSM