Access 2007 error - "Windows cannot find file....."

Posted on 2009-02-20
Last Modified: 2012-05-06
I am having a problem with an Access 2007 application that I built.  I split the database into front and and back end files.  The database file sits on a server and the front end is intalled on the desktop.  I have rolled out the application to 10 people successfully, and am having a problem with 2 people.  Everyone has proper network access to reach the back end database.  The 2 problem computers are running vista and office 2007, while the others are all running XP and office 2007.  When a user clicks on the .accdb file on their desktop, they get the following error message "Windows cannot find c:/Users\i812376\desktop\pat crotty\nucleus.accdb.  Make sure you typed the name correctly, and then try again." and the file does not open.

Here are a couple things that I have figured out while troubleshooting.
1. I created a small test .accdb file, and confirmed that they can open the file with no problems (This suggests that the problem might be related to the link between the front end and back end)
2. I have accessed the shared drive on the server where the back end database resides (proves that the users have access to the backend)
3. I put a copy of my front end file onto the problem computer, and it doesn't work on their computer, but still works on mine.  (suggests that the actual .accdb file is not corupt)
4. After reading some posts, I downloaded and installed office 2007 sp1 in hopes that it would fix the did not.
5. After doing some google searching of the error message, it seems like a lot of people have experienced this error message with other office files when running vista and office 2007.  
6. I tried entering Access 2007 and browsing to the file instead of opening it from the .accdb - this did not work.
Have you run into this problem or do you have any ideas on how I can fix it?  I really apprecaite any help you could provide!
Best regards
Question by:Clean14
    LVL 77

    Expert Comment

    ....error message "Windows cannot find c:/Users\i812376\des......
    Well there is an error there - or did you type this message into your question?

    Author Comment

    Sorry about that.  I did type the error message, and looks like I typed c:/ instead of c:\ by accident.  The error message should have read - "Windows cannot find c:\Users\i812376\desktop\pat crotty\nucleus.accdb.  Make sure you typed the name correctly, and then try again."
    LVL 12

    Accepted Solution

    The fact that the two problematic client are having vista installed probably means that the problem is probably because of UAC (User Access Control) try running access by right-click and select Run as Administrator.

    You can also set "Run as Administrator" permenantly by selecting "Run As Administrator" on the compatibility tab.

    Hope that helps,

    Author Closing Comment

    Thank you for your suggestion.  It did fix my problem.  Now I can actually enjoy my weekend!
    LVL 12

    Expert Comment

    Your Joy is my pleasure :)

    Featured Post

    How to run any project with ease

    Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
    - Combine task lists, docs, spreadsheets, and chat in one
    - View and edit from mobile/offline
    - Cut down on emails

    Join & Write a Comment

    We were having a lot of "Heartbeat Alerts" in our SCOM environment, now "Heartbeat" in a SCOM environment for those of you who might not be familiar with SCOM is a packet of data sent from the agent to the management server on a regular basis, basic…
    A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
    With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…
    The Task Scheduler is a powerful tool that is built into Windows. It allows you to schedule tasks (actions) on a recurring basis, such as hourly, daily, weekly, monthly, at log on, at startup, on idle, etc. This video Micro Tutorial is a brief intro…

    732 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

    Need Help in Real-Time?

    Connect with top rated Experts

    19 Experts available now in Live!

    Get 1:1 Help Now