Access 2010 (x86) on Windows 7 Pro (x64)

[sportsguy]

Queries result in Not Responding,

Access databases which were populated by XP were copies onto a shared drive for Windows 7 64 and Access 2010 for testing, and Access 2010 queries seem to blow up , access goes to not responding state.

What am i missing?

thanks
sportsguy

 

[dpw204]

Queries result in Not Responding,
Access databases which were populated by XP were copies onto a shared drive for Windows 7 64 and Access 2010 for testing, and Access 2010 queries seem to blow up , access goes to not responding state.

Here's a WAG (Wild Assumed Guess) -

- Are these clean copies? I've seen problems copying a file that is open and may have unsaved changes... Recommendation: Verify the database isn't in use when creating the copies.

- Have you tried Compact and Repair?

 

[sportsguy]

I am having the same problem with Access 2007 and windows 7 x64. With the task manager open, i see that the database is reading the table records into memory, and while access is performing that function, or so it appears, access shows Not responding. I am staring at this right at this moment.

Then I get a Windows 7 message this morning which says that the OS has tallied that my office applications are crashing often, and I suspect that its this sort of interoperability between 2007 and Win7 x64 pro interface.

any one else have the same issues?

sportsguy