Re: Required property of Primary Key fields

Tech-Archive recommends: Fix windows errors by optimizing your registry

Jamie Collins <jamiecollins@xxxxxxxxxx> wrote:

From what I read I understand you use spaces in metadata element names
(e.g. viewed tables)

No, I do not use spaces in table or field names. I do use them in
queries though.

and you don't user level security at all,

Correct.

which I
(and others writing SQL against you database) would find very annoying
and simply unworkable respectively. Each to their own, I guess :)

I don't understand what user level security has to do with queries.

And I find that it works quite well. Nothing irritating about it at
all.

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/
.

Relevant Pages

  • Re: Best Practice for tables?
    ... code one day in Access without writing SQL with at least one virtual ... and queries with spaces in the names make that completely ... Tony Toews, Microsoft Access MVP ... Microsoft Access Links, Hints, Tips & Accounting Systems at ...
    (microsoft.public.access.gettingstarted)
  • Re: Need some query design help....
    ... "Running Microsoft Access 2000" ... "SQL Queries for Mere Mortals" ... Then use an Update Query?? ... >> don't know how the if the temp tables would work properly. ...
    (microsoft.public.access.queries)
  • Re: Enter Parameter Value keeps appearing
    ... > report that lists Item, ... > problem is that Name is not in either of my queries or my ... Reserved Words in Microsoft Access' ...
    (microsoft.public.access.queries)
  • adding records and relationships in queries. relationship types
    ... The relationships in the queries are linked, but do not provide the same link as would the relation one to many in main database. ... "Running Microsoft Access 2000" ...
    (microsoft.public.access.queries)
  • Re: A common variable for many queries
    ... Doug Steele, Microsoft Access MVP ... 14 queries execute one after the other via a macro. ... A common field: Payroll date. ... I would like to add the possibility to specify which payroll date. ...
    (microsoft.public.access.queries)