Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

Excel/MS Access


  • Please log in to reply

#1
jojsh45

jojsh45

    Member

  • Member
  • PipPip
  • 58 posts
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?
  • 0

Advertisements


#2
dsm

dsm

    Member

  • Member
  • PipPip
  • 98 posts
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
  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP