Sharepoint List relationships listed as "Indeterminate" when imported to Access?

  • Thread starter Thread starter Microsoft
  • Start date Start date
M

Microsoft

Hi -

MOSS 3.0, Access 2007.

When I import related lists from Shareoint into Access, the relationships
that come through are listed as "indeterminate," and it is not possible to
enforce referential integrity. Can anyone explain this?

Thanks - t
 
Microsoft said:
When I import related lists from Shareoint
into Access, the relationships that come
through are listed as "indeterminate," and it
is not possible to enforce referential integrity.
Can anyone explain this?
Click to expand...

SharePoint does not support referential integrity, nor, as far as I know,
relationships. Thus I am not surprised that Access would view the
relationship as "indeterminate." I would expect that once you _import_,
not _link_, the tables they are no longer anything to do with SharePoint and
should work just as any other Access table. What you describe is just what
I would expect to see when _linking_ to SharePoint lists.

Larry Linson
Microsoft Access MVP
 
Back
Top