ACCESS-L FAQ

This FAQ sheet is a compilation of Access-L posts to common questions. The posts here are the best of the best of Access-L. If you are a new user of Access, this should be your first resource when asking a question. Chances are good that someone else has asked it before. If you cannot find your question here, your next stop should be the Access-L archives at: http://peach.ease.lsoft.com/scripts/wa.exe?S1=access-l There you will find answers to many more of your questions.

Viewing many of these posts requires a subscription to Access-L discussion group. To get a free subscription to Access-L, go to: http://peach.ease.lsoft.com/archives/access-l.html#SUB

 

Table of Contents

1) How do I Unsubscribe from Access-L How do I temporarily discontinue Access-L postings (nomail) How do I set digest mode *

2) Why use a FrontEnd/BackEnd database architecture? *

3) Why should I use an AutoNumber field as a primary key? *

4) What ARE the Access-L Fees and who are the Fees Committee? (humor… I suppose) *

5) I need help with Access Security *

6) Problems with References *

7) Unique Indexes and Surrogate Keys *
  1. How do I Unsubscribe from Access-L
    How do I temporarily discontinue Access-L postings (nomail)
    How do I set digest mode

    2. http://peach.ease.lsoft.com/scripts/wa.exe?A2=ind0205b&L=access-l&P=16659

    Modify your settings through email

    LISTSERV General User's Guide.

    Modify your settings through the web

    through a web form

  2. Why use a FrontEnd/BackEnd database architecture?

    3. http://peach.ease.lsoft.com/scripts/wa.exe?A2=ind9811C&L=access-l&P=R10123

    http://peach.ease.lsoft.com/scripts/wa.exe?A2=ind0112A&L=access-l&P=R1810

     

  3. Why should I use an AutoNumber field as a primary key?

    4. http://peach.ease.lsoft.com/scripts/wa.exe?A2=ind0112A&L=access-l&P=R19613

    http://peach.ease.lsoft.com/scripts/wa.exe?A2=ind0112A&L=access-l&P=R17559

     

  4. What ARE the Access-L Fees and who are the Fees Committee?
    (humor… I suppose)

    5. http://peach.ease.lsoft.com/scripts/wa.exe?A2=ind9909A&L=access-l&P=R2036

     

  5. I need help with Access Security

    6. MS Access Security FAQ

    http://support.microsoft.com/support/access/content/secfaq.asp

    Access Security And Passwords

    http://www.vb123.com/toolshed/00_accvb/accesssecurity.htm

    Links for resources on Access Security

    http://www.vb123.com/toolshed/links/access_security.htm

    ACC: Overview of How to Secure a Microsoft Access Database (Q132143)

    http://support.microsoft.com/default.aspx?scid=kb;EN-US;q132143

    Some articles from Access-L Archives:

    Item #132606 (11 Dec 2001 20:54) - Re: Access 97 Security MDW

    Item #132247 (6 Dec 2001 07:32) - Re: Convert to Access 2002 from Access97 w/Security - newbie

    Item #132294 (6 Dec 2001 08:55) - Re: Recplication and Security

     

  6. Problems with References

    7. There is a variety of ways that Reference problems manifest themselves. Most commonly a built in Access function like Right() or Mid() or Date() will stop working with an error complaining about user defined functions. Another common indication is when you get an error about a user-defined object with the code: Dim db as Database:

    http://peach.ease.lsoft.com/scripts/wa.exe?A2=ind0201A&L=access-l&P=R1404

    http://peach.ease.lsoft.com/scripts/wa.exe?A2=ind0203A&L=access-l&P=R14544

     

  7. Unique Indexes and Surrogate Keys

Why do we use Unique Indexes when we have an Autonumber Primary key (Surrogate Key)

http://peach.ease.lsoft.com/scripts/wa.exe?A2=ind0302d&L=access-l&P=9425