Avatar of Alaska Cowboy
Alaska Cowboy
Flag for United States of America asked on

Can't see table design view in Access 2010

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
Microsoft Access

Avatar of undefined
Last Comment
Alaska Cowboy

8/22/2022 - Mon
SOLUTION
Flyster

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Alaska Cowboy

ASKER
Flyster, I don't see Design - only Datasheet . . .

right click doesn't work either, only option is "Open" which opens data-sheet view.
View options for table
ASKER CERTIFIED SOLUTION
Jeffrey Coachman

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
Alaska Cowboy

ASKER
Jeff,

ok, now I get it. I started with a template from Microsoft, Contacts d.b., and it was very good with some good forms and stuff, but then I kept running into problems like this one.

So this is a related question because I think it's what got me into trouble when I dove head first into this project, but I assume that the "lookup" feature in the datasheet view is NOT the way to go . . . so I am planning on re-designing this by creating the tables normally, with foreign keys . . .
SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Alaska Cowboy

ASKER
Jeff,

yes, no web for me . . . I dived headfirst into Access  2010 and got twisted up like a pretzel, and you were probably trying to rescue me on some of my recent posts . . .

So I am just starting from scratch in a normal way, no lookup, no web . . . thanks.
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
Jeffrey Coachman

Just to be clear, then you may want to start over with a standard database
Alaska Cowboy

ASKER
Jeff,

yes, I started over and it went slick as a whistle . . . what a quicksand I got into. Thanks.
Alaska Cowboy

ASKER
After a rough start diving headlong into Access 2010, I am now doing very well.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.