Access 2010 datasheet view only/relationships unavailable
- by Luis
I'm relatively new to MS Access in general and just started working with Access 2010. I've created a new web database with a few tables that I need to relate.
First problem: For the life of me, I can't view anything in any view other than datasheet view; everywhere I would expect to be able to change the view, only datasheet view is available.
Second problem: I can't change the primary key(s). Presumably I would be able to do this if I could get out of datasheet view and into design view.
Third problem: The 'Relationships' button is greyed out.
I know these appear to be really simple things but I've been looking for much more time than I'd like to admit trying to figure out how to get unstuck.
Update: It would appear that this is happening because it is a 'web database' as I've been able to do all of the above in a new regular database. With this in mind let me ask a different question: Am I able to add relationships and change primary keys in a web database? If so how? More generally, what is the point of a web database?