Linking Outlook Contacts to Access doesn't allow setting a key fie

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

After linking my Outlook contacts to create an Access table, I am limited in
how to use the table and create relationships since it does not allow me to
set a primary key field in that table. Is this the nature of linking to
Outlook or is there something else I am missing here?

Thanks for any helpful ideas.
 
Hi Ronny,

As far as I know that's the way it is. Outlook contacts (and
appointments and so on) do actually have a unique identifier, but it's
not exposed for linking and as far as I can remember may be more than
255 characters long, which means it couldn't be stored in an indexable
field in an Access/Jet table anyway.

On Wed, 18 May 2005 09:50:28 -0700, "RonnyK at CTS" <RonnyK at
 
Yes, you have missed something! There is actually a primary key field defined
for you... The "Display as" field is the one - and that field must be
non-null for all linked records, which is a nuisance to me. Either you have
to fill that field manually with a unique identifier, which is not disturbing
the outlook procedures - or ...???
 
Hi Gunnarh,

Ii sounds like I am having similar issues to you with the "Display as" field.
How did you get around it in the end (or is it still unsolved)?

I am trying to link recods from Outlook with only a first name and a phone
number. Even if I type something unique in the "display as" field it does
not appear in the link table.
 
I too wish to link my contacts to another table (meetings) but can't without
a primary key.

can anyone help please....?
 
Back
Top