Access table won't open

Question

I am running an Access 2000 database in Access 2007.   Another user is running the same database in 2007 without a problem, so I don't think that's the issue, although I have tried saving it as a 2003 file as well.  There is one small table, not linked, that will not open.  It is under 100 records, 3 columns, just a list of dates basically.  I can open it in design view, but if I try to open it in datasheet view, I see only the first record, and then Access locks up indefinitely (until I do a shutdown; ctrl-brk or escape do not work).  I have tried exporting the data to Excel, and then importing it to an entirely new table in Access, and I get the exact same error.

I am about to tear my hair out, so any ideas are much appreciated!  I have tried a compact and repair, changing settings, enabling macros. . .

Answer 1

Hi lmkatz,

It sounds like you might be running into the issue described in the article below:

2397391 Microsoft Access stops responding on Hewlett-Packard (HP) machines with Digital Persona Biometric device

http://support.microsoft.com/default.aspx?scid=kb;en-US;2397391

Best Regards,

Nathan Ost

Microsoft Online Community Support

---

Please remember to click "Mark as Answer" on the post that helps you, and to click "Unmark as Answer" if a marked post does not actually answer your question. This can be beneficial to other community members reading the thread.

Answer 2

Nathan, you are my hero!!!!  Thank you so much!  This has been eluding both me and my IT dept for days!

Answer 3

<lmkatz> wrote in message news:*** Email address is removed for privacy ***...

 I am running an Access 2000 database in Access 2007. Another user is running the same database in 2007 without a problem, so I don't think that's the issue, although I have tried saving it as a 2003 file as well. There is one small table, not linked, that will not open. It is under 100 records, 3 columns, just a list of dates basically. I can open it in design view, but if I try to open it in datasheet view, I see only the first record, and then Access locks up indefinitely (until I do a shutdown; ctrl-brk or escape do not work). I have tried exporting the data to Excel, and then importing it to an entirely new table in Access, and I get the exact same error.

It sounds like a corrupt database. Try using a copy of the same front-end as the other user is.

---

Arvin Meyer, MCP, MVP

http://www.datastrat.com

http://www.accessmvp.com

http://www.mvps.org/access

Co-author: "Access Solutions", published by Wiley

---

Arvin Meyer MCP, MVP MS-Access http://www.datastrat.com http://www.accessmvp.com http://www.mvps.org/access Co-author: "Access Solutions", published by Wiley