Any Problems with Access 2007 apps running on Windows 7

Posted on 2011-04-19
Last Modified: 2012-05-11
I have a series of apps created in Access 2007 with SQL Server 2005 as the back end database.  All of my users so far are all running Windows XP.  

Now, the company is migrating to Windows 7.

If anyone has already done this, is it a seamess migration or can I expect problems?  Minor or major?
Question by:wsturdev
    LVL 74

    Assisted Solution

    by:Jeffrey Coachman
    There have been numerous issues reported.
    Most surrounding the 64bit version...

    You may want to search here for some links on this....
    LVL 84

    Accepted Solution

    As Jeff said, it's the 64-bit stuff that will get you. If you're sticking with 32-bit versions, you'll have no troubles.

    Even with 64-bit operating systems, you'll be okay if you do NOT use 64-bit versions of Office and such. You should stick with the 32-bit versions of those programs.

    One of the biggest issues with Windows 7 is the concept of folder virtualization. If you've been installing your Access databases to C:\Program Files, you'll find that you cannot do so effectively on Windows 7 machines. Instead, you'd use <root>\ProgramData or perhaps Users\AllUsers or Users\<YourUserName>, depending on the share level you need.

    Also be aware of the networking issues with Win7 machines and XP machines. This can be a realy bugger to fix - Win7 and XP often have issues connecting via typical LAN configurations. You may have IT people that can deal with this, but if you're expected to do all of this, make sure to get the networking fully functional before moving the databases.
    LVL 1

    Author Closing Comment

    Both resonders gave the same essential response, but LSM Consulting offered important and valuable additional information.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
    Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
    Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
    Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

    734 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

    20 Experts available now in Live!

    Get 1:1 Help Now