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

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

When you use SharePoint with Access, you can kiss your relationships goodbye.
Sorry. That's the way it is. SharePoint works great with lists of data, and
that's exactly how it treats the tables in your database--as lists only.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/ex...tributors.html
__________________________________________

"Microsoft" wrote:

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" wrote

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