• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 329
  • Last Modified:

Any Problems with Access 2007 apps running on Windows 7

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?
0
wsturdev
Asked:
wsturdev
2 Solutions
 
Jeffrey CoachmanMIS LiasonCommented:
There have been numerous issues reported.
Most surrounding the 64bit version...

You may want to search here for some links on this....
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
0
 
wsturdevAuthor Commented:
Both resonders gave the same essential response, but LSM Consulting offered important and valuable additional information.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now