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

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
 
L

Larry Linson

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?

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top