I'm building a table in Access and here are some columns:
UserID, UserName, UserPassword, Userlevel etc.
If I put a multiple field Primary key on UserID and Username will I also
have to add a separate index to Username?
Is MS Access or MS Jet smart enough to split the multiple field PK and use
each column separately (when needed?).
--
Michael She
I m a g i n e C o m m u n i c a t i o n s
Company E-mail: [EMAIL PROTECTED]
Personal E-mail: [EMAIL PROTECTED]
ICQ UIN: #243466
Personal Homepage: http://www.michaelshe.com (Under Construction)
Imagine Communications: http://www.imagineer.net
PGP Fingerprint: 9A24 1DA9 39B8 0A0C C5ED 6E5D 45E9 075A 51CD 66A1
------------------------------------------------------------------------------------------------
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists or send a message
with 'unsubscribe' in the body to [EMAIL PROTECTED]
