M
MYL
Is it ok to not have a primary key for mailing lists?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arvin Meyer [MVP]
MYL said:Is it ok to not have a primary key for mailing lists?
The only time a Primary Key becomes an absolute requirement is when you have
related tables. If your mailing list never has more than 1 address per
person and you don't care about possible duplicate values, then you do not
need to have a primary key. OTOH, if you use an autonumber, why does it
matter?
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
6
'69 Camaro
Hi.
If:
1.) This is a temporary table that you are going to delete during the
current session; and
2.) This table has no relationship with any other table in the database; and
3.) You aren't worried about duplicate entries
.... then you can probably get away with not adding a primary key.
However, if you are going to keep this table in the database for any length
of time beyond today, or this table has a relationship with any other table,
or you need to prevent duplicate entries, then you should probably have a
primary key on this table.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
Is it ok to not have a primary key for mailing lists?
If:
1.) This is a temporary table that you are going to delete during the
current session; and
2.) This table has no relationship with any other table in the database; and
3.) You aren't worried about duplicate entries
.... then you can probably get away with not adding a primary key.
However, if you are going to keep this table in the database for any length
of time beyond today, or this table has a relationship with any other table,
or you need to prevent duplicate entries, then you should probably have a
primary key on this table.
HTH.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
(Please remove ZERO_SPAM from my reply E-mail address so that a message will
be forwarded to me.)
- - -
If my answer has helped you, please sign in and answer yes to the question
"Did this post answer your question?" at the bottom of the message, which
adds your question and the answers to the database of answers. Remember that
questions answered the quickest are often from those who have a history of
rewarding the contributors who have taken the time to answer questions
correctly.
A
AL FINK
The short answer is yes
but as mensioned in others post here this may not be what you want.
Something to think about is usings your email field as a key field if for no
other reason, but to make sure you have no dup. records.
but as mensioned in others post here this may not be what you want.
Something to think about is usings your email field as a key field if for no
other reason, but to make sure you have no dup. records.
6
'69 Camaro
Sorry to bother you, but it appears that you've marked my post above as an
answer to your question. Unfortunately, the Web portal is still rather
buggy and it didn't recognize you as the original poster of the question.
Would you please do me a favor and sign in again to the Microsoft Online
Community with your .Net Passport and try to mark the "Did this post answer
your question?" question on my previous post until a green check mark shows
up? (Refresh the page about a minute later and the green check mark should
appear.)
Thanks! It's greatly appreciated.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.
answer to your question. Unfortunately, the Web portal is still rather
buggy and it didn't recognize you as the original poster of the question.
Would you please do me a favor and sign in again to the Microsoft Online
Community with your .Net Passport and try to mark the "Did this post answer
your question?" question on my previous post until a green check mark shows
up? (Refresh the page about a minute later and the green check mark should
appear.)
Thanks! It's greatly appreciated.
Gunny
See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.