Help! I can't see the data in my tables (A2010)
in [Help]
|
Prev: Reading the Value or Caption From an OPtion Group Button usingSelect Case??
Next: Operation must use and updatable query
From: andrewmrichards on 1 Aug 2010 17:15 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
From: David W. Fenton on 1 Aug 2010 21:00 andrewmrichards <andrew.richards(a)theitservice.co.uk> wrote in news:3cf8a715-501f-46db-8c42-be0bac711243(a)f6g2000pro.googlegroups.com : > I have just purchased a new laptop, with Windows 7 and Office 2010 > (both 64 bit). MS is recommending *against* installing 64-bit Office. -- David W. Fenton http://www.dfenton.com/ contact via website only http://www.dfenton.com/DFA/
From: andrewmrichards on 2 Aug 2010 09:43 On Aug 2, 2:00 am, "David W. Fenton" <NoEm...(a)SeeSignature.invalid> wrote: > andrewmrichards <andrew.richa...(a)theitservice.co.uk> wrote innews:3cf8a715-501f-46db-8c42-be0bac711243(a)f6g2000pro.googlegroups.com > : > > > I have just purchased a new laptop, with Windows 7 and Office 2010 > > (both 64 bit). > > MS is recommending *against* installing 64-bit Office. > > -- > David W. Fenton http://www.dfenton.com/ > contact via website only http://www.dfenton.com/DFA/ 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
From: Douglas J. Steele on 2 Aug 2010 13:03 "andrewmrichards" <andrew.richards(a)theitservice.co.uk> wrote in message news:0b7297fa-d5be-45a3-8b09-7a214692e4de(a)z30g2000prg.googlegroups.com... On Aug 2, 2:00 am, "David W. Fenton" <NoEm...(a)SeeSignature.invalid> wrote: > andrewmrichards <andrew.richa...(a)theitservice.co.uk> wrote > innews:3cf8a715-501f-46db-8c42-be0bac711243(a)f6g2000pro.googlegroups.com > : > >> > I have just purchased a new laptop, with Windows 7 and Office 2010 >> > (both 64 bit). >> >> MS is recommending *against* installing 64-bit Office. > > 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. The Microsoft Office 2010 Technology Guarantee FAQ (which you can find at http://office2010.microsoft.com/en-us/tech-guarantee/microsoft-office-2010-technology-guarantee-faq-HA101812304.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/Forums/en/office2010/thread/40d17c38-90e0-48d9-8f83-d9721a24b063 -- Doug Steele, Microsoft Access MVP http://www.AccessMVP.com/djsteele Co-author: "Access 2010 Solutions", published by Wiley (no e-mails, please!)
From: andrewmrichards on 3 Aug 2010 10:40
On Aug 2, 6:03 pm, "Douglas J. Steele" <NOSPAM_djsteele(a)NOSPAM_gmail.com> wrote: > "andrewmrichards" <andrew.richa...(a)theitservice.co.uk> wrote in message > > news:0b7297fa-d5be-45a3-8b09-7a214692e4de(a)z30g2000prg.googlegroups.com... > On Aug 2, 2:00 am, "David W. Fenton" <NoEm...(a)SeeSignature.invalid> > wrote: > > > andrewmrichards <andrew.richa...(a)theitservice.co.uk> wrote > > innews:3cf8a715-501f-46db-8c42-be0bac711243(a)f6g2000pro.googlegroups.com > > : > > >> > I have just purchased a new laptop, with Windows 7 and Office 2010 > >> > (both 64 bit). > > >> MS is recommending *against* installing 64-bit Office. > > > 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. > > The Microsoft Office 2010 Technology Guarantee FAQ (which you can find athttp://office2010.microsoft.com/en-us/tech-guarantee/microsoft-office...) > 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 readhttp://social.technet.microsoft.com/Forums/en/office2010/thread/40d17... > > -- > Doug Steele, Microsoft Access MVPhttp://www.AccessMVP.com/djsteele > Co-author: "Access 2010 Solutions", published by Wiley > (no e-mails, please!) Interesting.... Thanks for that. Anyone by ideas on my original issue? Still being plagued by that one and can't find a solution. :-( Andrew |