?
Solved

the microsoft jet database engine cannot open the file <File Name> make sure it exists and that its name is spelled correctly

Posted on 2011-04-21
4
Medium Priority
?
523 Views
Last Modified: 2012-05-11
Hello Experts,

Firstly let me just say that I'm a novice at best with Access so please try to make the explanations more detailed than usual.

Now to the issue at hand.

I have an Access database that has a link to a central database off site.  All has been working well and recently we did an update to the Data Source Connection and all worked OK for the last 2 months and now when the user tries to access the database on the computer and run a query the following message comes up "the Microsoft jet database engine cannot open the file dbo_prospect make sure it exists and that its name is spelled correctly"

I've rebooted the server, ran a chkdsk and looked for answers online but have not been able to find a resolution. I did find this from Microsoft ( http://support.microsoft.com/kb/287696 ) but as I mentioned before I'm a novice w/ Access so this was of no help to me.
I've also added the image of the error in case it's needed.

Any help would be appreciated and thank you in advance.

Sebastian  Error Message
0
Comment
Question by:1pcxpert
  • 3
4 Comments
 
LVL 7

Accepted Solution

by:
RemRemRem earned 2000 total points
ID: 35443381
If you are in fact linking to dbo_Prospect via ODBC, you can go into your user's Control Panel, check that they have the ODBC connection you expect is there, and step through it, hitting the TEST option. If it tests out fine, the next step is to check the server to see if the table called Prospect is actually ON that server location. If it is AND your ODBC connection is functional to that server, you may need network support for rights issues.

Alternatively, if you have code running automatically in the database which, for some reason, deletes and recreates the table dbo_Prospect, it may have gotten stuck halfway through the process at some point. In that case, go to the back side of the Access database and do a LINK back to the original table, compact and repair the Access database and try running things again.

-Rachel
0
 

Author Comment

by:1pcxpert
ID: 35461319
Thanks for the quick reply, I'll test it today and will get beck to you.
0
 

Author Comment

by:1pcxpert
ID: 35465026
Hello again RemRemRem,

Followed your steps and your recommendation to  "check the server to see if the table called Prospect is actually ON that server location." found me the problem.  IT turns out that the dbo_Prospect table was not Linked since the last update of the database. Once I reconnected it  it all came back to normal.
Thank you so much for your help. It is appreciated.

Sebastian
0
 

Author Closing Comment

by:1pcxpert
ID: 35465030
Followed recommendation to  "check the server to see if the table called Prospect is actually ON that server location." found me the problem.  IT turns out that the dbo_Prospect table was not Linked since the last update of the database. Once I reconnected it  it all came back to normal.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In today's business world, data is more important than ever for informing marketing campaigns. Accessing and using data, however, may not come naturally to some creative marketing professionals. Here are four tips for adapting to wield data for insi…
If you’re using QODBC to update QuickBooks data from Microsoft® Access but Access is not showing the updated data, you could have set up QODBC incorrectly.
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Look below the covers at a subform control , and the form that is inside it. Explore properties and see how easy it is to aggregate, get statistics, and synchronize results for your data. A Microsoft Access subform is used to show relevant calcul…

840 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question