No. of Recommendations: 0
I have Access 2010 (32-bit) installed and I hadn't noticed that problem, and I use the datasheet view all the time.

Are you displaying the names of the table on the left (the Shutter Bar)? If so, just double-click on a table name.

If you are not displaying the table names, on the Shutter Bar, select "Object type". Then on the Shutter Bar, select "Tables". (It seems odd to have to do this in two steps, but that is what works for me.) Or you could use "All object types" if your Access database doesn't have a lot of objects in it.

But as I said, I have had no problems with this. But then shortly after I had upgraded to Access 2007, I upgraded the databases to Access 2007 format, and when I upgraded from that to Access 2010 it was just a matter of getting used to the new interface and making good use of it (I implemented "custom categories" on a couple of my databases). The format of the database is displayed in Access in the title bar (e.g., "database name: Database (Access 2007 - 2010) - Microsoft Access"). So, if you are upgrading from a pre-Access-2007 format, I would recommend making a copy of that database and then go through the exercise of upgrading the database to Access 2007-2010 format (in Access 2010: "File" -> "Save & Publish" -> Save database as "Access Database (*.accdb)").
Print the post  


When Life Gives You Lemons
We all have had hardships and made poor decisions. The important thing is how we respond and grow. Read the story of a Fool who started from nothing, and looks to gain everything.
Contact Us
Contact Customer Service and other Fool departments here.
Work for Fools?
Winner of the Washingtonian great places to work, and Glassdoor #1 Company to Work For 2015! Have access to all of TMF's online and email products for FREE, and be paid for your contributions to TMF! Click the link and start your Fool career.