We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

Seb
Seb asked
on
Medium Priority
542 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
Comment
Watch Question

Unlock this solution with a free trial preview.
(No credit card required)
Get Preview
SebSystems Admin

Author

Commented:
Thanks for the quick reply, I'll test it today and will get beck to you.
SebSystems Admin

Author

Commented:
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
SebSystems Admin

Author

Commented:
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.
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.