I have Windows 7 Professional 32 bit. I have installed multiple versions of Access (XP, 2003, 2007 and 2010) as I do Access database work. I installed in separate folders and ran all the fixes and updates.
When working in 2007 or 2010 on a database designed in 2002-03 format, I cannot view about 1/2 the tables. I can view the table design just fine. This works for linked tables in front end and normal tables in backend. The other elements of the database appears to work fine. When trying to open those specific tables, Access ends up non-responding and I have to close via task manager. The databases work fine in Access XP/2003. The databases work fine in 2007/2010 on machine running Windows XP Pro.
Is there a known problem with Access 2007/2010 running previous Access databases on Windows 7?
Thanks