Recent content by geister

Not sure myself, I do use a VPN so sometimes sites don't like that.

Thank you, this makes sense. It is a shame there is no direct button, but this is close enough.

SQL view in Access. And to load it up directly without using the Query Wizard or Query Design.

Is there any way to open up SQL view directly?

I'm ignoring the last few lest I end up confused! How about when to allow duplicates or not? Also sorry for the dumb questions. I'm from the school of just ask, no matter how dumb.

One follow up, when ye are deciding what to index - at the most basic level - what are you looking for? It seems to me that most small databases would not need to pay attention to this (leaving aside primary key auto-indexing). Are there any general rules for thinking about when and when not...

Thanks both, I should have trusted my own understanding here rather than overthinking it.

So it is kind of another way of enforcing integrity?

Hi there, I am new to access and learning it because I want to understand relational databases without getting into SQL just yet. I have a few areas that confuse me, but one that makes little sense to me is indexing. The answer is maybe obvious, but what difference does it make to allow...