Hi All

I'm in real need of some help.

I have a database which was originally created in Access 2007, as an
MDB file (my client uses A2003 and A2007),

I have just purchased a new laptop, with Windows 7 and Office 2010
(both 64 bit).

If I open the application I have developed, and use it by means of the
forms that I've designed, all works well.

However, if I try to open any of the tables, whether in the front end
or directly in the back end, the table begins to open, I see the first
value in the first column of the first row, and the rest of the screen
is just grey, as though it can't be drawn, and Access goes to "Not
responding".

If it helps, I've posted a couple of screenshots:
As the data should look: http://theitservice.co.uk/access/data.png
As it looks if I open it in Access: http://theitservice.co.uk/access/accessissue.png

One or two more points in case they are of help:
1) I tried originally in Office 2010 (32 bit) on this laptop, and got
the same result (That's partly why I installed the 64-bit edition, in
case there was some conflict between the 32 bit edition of Office and
the 64 bit edition of Windows)
2) I tried in Office 2007 on this same laptop and got the same result
again.
3) In order to see if I could access the data another way, I tried
linking Excel to my database and opening the table in Excel, and it
worked perfectly
4) I then tried again to open the database in Access, and - because
Excel still had a connection to the database - was asked if I wanted
to open it as Read Only. I said "Yes" and then tried to open the table
one more time. It opened perfectly and I could see all the data.
5) When Access goes into its "Not responding" state, the CPU does not
seem busy (only around 5% utilization) and the hard disk was not being
accessed unduly.

HELP! Has anyone else seen or heard of this before? I'd be really
grateful for any help.

Best regards

Andrew

andrewmrichards <andrew.richards (AT) theitservice (DOT) co.uk> wrote in
news:3cf8a715-501f-46db-8c42-be0bac711243 (AT) f6g2000pro (DOT) googlegroups.com
:

MS is recommending *against* installing 64-bit Office.

--
David W. Fenton http://www.dfenton.com/
contact via website only http://www.dfenton.com/DFA/

On Aug 2, 2:00*am, "David W. Fenton" <NoEm... (AT) SeeSignature (DOT) invalid>
wrote:
Can you enlighten me as to why?!!

Although I don't think it's relevant to this question (had the 32-bit
version on there first) I'm interested as to their logic in
recommending against one of their products! I'll have to do some
reading.

Andrew

"andrewmrichards" <andrew.richards (AT) theitservice (DOT) co.uk> wrote

On Aug 2, 2:00 am, "David W. Fenton" <NoEm... (AT) SeeSignature (DOT) invalid>
wrote:
The Microsoft Office 2010 Technology Guarantee FAQ (which you can find at
http://office2010.microsoft.com/en-u...101812304.aspx )
states

"Yes, 64-bit Office 2010 product upgrades will be available. However we
strongly recommend most users install 32-bit version of Office 2010 on both
32 and 64-bit Operating Systems because currently many common add-ins for
Office will not function in the 64-bit edition. The 64-bit installation of
Microsoft Office 2010 products will be available for users who commonly use
very large documents or data set and need Excel 2010 programs to access
greater than 2GB of memory. There may be technical issues with the 64-bit
version and in order to install a 64-bit version of Office 2010 product
users must have a 64-bit supported operating system on their PC."

You might also read
http://social.technet.microsoft.com/...3-d9721a24b063

--
Doug Steele, Microsoft Access MVP
http://www.AccessMVP.com/djsteele
Co-author: "Access 2010 Solutions", published by Wiley
(no e-mails, please!)

On Aug 2, 6:03*pm, "Douglas J. Steele"
<NOSPAM_djsteele (AT) NOSPAM_gmail (DOT) com> wrote:

Interesting....

Thanks for that.

Anyone by ideas on my original issue? Still being plagued by that one
and can't find a solution. :-(

Andrew

This is exactly the problem I am having with some of my temporary tables created through an sql make table. I have recently started using Windows 7 and Office Professional 2010. I have been able to get some of them working, but can't see what I'm doing differently. Has there been an answer to this problem? Database was originally created using A2003

On 17/02/2011 00:37:35, Elinor McLean wrote:
Phil

Tried this - doesn't make any difference. Data still isn't displayed, and Access hangs.

Submitted via EggHeadCafe
WCF Generic DataContract object Serializer
http://www.eggheadcafe.com/tutorials...erializer.aspx

"Elinor McLean" <elinor_mclean (AT) hotmail (DOT) com> wrote


I just noticed this post above:

"slowwww database performance in Access 2007/2010 on Win7"
(by Owen et al)

- I have the same problem with 2007/Vista on one of my PCs, which is an HP.
Maybe tha HP fingerpring recognition software (HP SimplePass Identity
Protection) is the problem, but I have a different version on my machine
("Digital Persona").

I haven't resolved the issue and it never happens on any of my other
(non-HP) machines but I have a kind of work-around: open any table in Design
View first (even if you get an error message because it's linked) then
immediately switch to Datasheet view - works instantly every time. No idea
why!

Cheers
Malcolm