MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

Jet Database Engine Error

  Asked By: Fern    Date: Jan 25    Category: MS Office    Views: 1554

I've been working with a lot of VBA in Excel using the ADO to query a
named range in a spreadsheet.

It works with Excel 2003 SP2 and Excel 2002. However, the same
workbook on one of my co-worker's computers it doesn't work. He's
using Excel 2003. It gives me an error stating the following:

"Microsoft Jet Database Engine could not find the object 'MyNamedRange'".

My guess is that it has something to do with .dll versions or
something along those lines. It doesn't make sense that it would
otherwise work on a previous and post version of Excel.



1 Answer Found

Answer #1    Answered By: Paulette Matthews     Answered On: Jan 25

I'd be looking first at environmental things rather than software
incompatibilities. Are the file permissions right? Have you got the path and
workbook name exactly right? Is the workbook even there? Is everything on the
machine "the same" as the one that is known to work with 2003? Does Access work
properly by itself on the machine?

Chances are that its an environmental difference of a "silly" error.

Didn't find what you were looking for? Find more on Jet Database Engine Error Or get search suggestion and latest updates.