troubleshooting Question

Can't see table design view in Access 2010

Avatar of Alaska Cowboy
Alaska CowboyFlag for United States of America asked on
Microsoft Access
9 Comments3 Solutions4811 ViewsLast Modified:
I dived into Access 2010 and got stuck in the mud. So I'm trying to start with a clean slate.

I am trying to create tables and I cannot see the Design view, only the Datasheet view, see screen shot.

So I created tables that have foreign keys to other tables, but in the Datasheet view I created the FK fields via Lookup, so that masked the actual foreign key, and I believe this has caused me some undue pretzel twisting in some of my forms and stuff.

So I am just trying to figure out why I can't see the table design view. If I did, I would be able to set up the table in the normal manner, which I am capable of doing (from my experience with Access 2000 and Oracle).

Notice in the screen print the table has the "web'y" icon, is that right ?

table design not available
Join our community to see this answer!
Unlock 3 Answers and 9 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 3 Answers and 9 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros