Can't see table design view in Access 2010

Alaska Cowboy
Alaska Cowboy used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
In the upper-left hand corner you have the Views button. Click that and you should get all the view options. Also, if you right-click the table name, you should get the design option.

Flyster

Author

Commented:
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
MIS Liason
Most Valuable Expert 2012
Commented:
If that is a web database (which yours looks like, based on your screenshot) you wont have a "Design View" of a table...

You have to click the "Fields" tab on the ribbon to access the things you normally do in design view of a standard access database table.
screenshot
JeffCoachman
Success in ‘20 With a Profitable Pricing Strategy

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
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 . . .
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012
Commented:
First question...
Does this *really need* to be a web database?

These are radically different from standard databases.
It's not as easy as just "Putting them on the web", and having them work like Ebay or Amazon.

To date, I have never seen a working MS Access web database deployed over the web.
(I know that some must exist, but none that I know of.)

Remember, most web databases are sql Server or MySQL in the backend and some dedicated "web interface" (.net, asp, php, ...et al)

So there may not be that much support available for web databases, ...if you get into trouble...(Macros, Deployment, scalability, security, ...etc)

If you really need your db accessible over the web you can see this too:
http://eqldata.com/onweb/

Second:
<I assume that the "lookup" feature in the datasheet view is NOT the way to go>
Lookups are dangerous in tables because they confuses things.
I guess you have seen this:
http://access.mvps.org/access/lookupfields.htm

Lookup fields are also not currently supported by SQL server (or MySQL, or Oracle, directly.
These are "MS Access Only" constructs.

JeffCoachman

Author

Commented:
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.
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
Just to be clear, then you may want to start over with a standard database

Author

Commented:
Jeff,

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

Author

Commented:
After a rough start diving headlong into Access 2010, I am now doing very well.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial