Anyone had problems with Access on Windows 7 (reports/controls)

[AnitaPita]

Has anyone had any problems with Access 2007 running on Windows 7? I have had a lot of random issues and suspected it may be due to Windows 7....spent many hours this week troubleshooting reports I have built, mainly because IIF statements were not working in a control source. I finally rebuilt the tables/reports on my home computer (also Access 2007 but running XP) and everything worked fine.

Not sure what to do now, this database/reports are needed by my department and I cannot finish because these statements aren't working. It doesn't return any errors, just shows as a blank box when I view the reports. :/

 

[Halle]

Wow..

I was going to write a thread last night asking the exact same thing but for Access 2003. Can Access 2003 functions, macros and reports running well on a 64bit system. I took a course in database connectivity where we had to design VB.NET applications using Access 2007 as a data source. It was recommended to us by our professor to only use a 64bit system to do our work. If someone did have to use a 32bit system, they were told to set VB.NET to compile at (x86).

I am also looking forward to seeing what other say about your question. Thanks for asking!

 

[boblarson]

AnitaPita:

Where do you have the database located on the Windows 7 machine? It can't be in a folder under Program Files, nor can it be in the root "C" directory. Also, have you set the database location to be a Trusted Location for each computer using it?


Halle:
Access 2003 and 2007 are ONLY 32 bit systems. There is no 64 bit version of Office in those versions. And 32 bit versions of Access (and Office, period) work just fine on a 64 bit Operating System. The 64 bit version of Office is not really suggested to be used at this time because there are still issues outstanding with it and, unless you are doing mega data calculations in an Excel Spreadsheet, you will not have any good reason to use it.

Using the 64 bit Operating System is a good thing as it can utilize more memory so yes, your professor was correct about that.

 

[jdraw]

These links may be of interest to people running Windows 7 SP1 and having errors

http://social.msdn.microsoft.com/Forums/en-US/isvvba/thread/508fa044-93f0-48be-b5c0-82b83fcdde0e/

http://support.microsoft.com/kb/2517589