Table relationships - adding and deleteing via code

D

Dale Fye

I'm working with Sharepoint 2007 lists as links in an Access database. I
want to be able to add and drop the tables, but when I link to a Sharepoint
list, it automatically also links to the Sharepoint User Information List (to
provide referential integrity for the Created By and Modified By fields.

Unfortunately, when I go to delete a table, I get an error (#2387) advising
me that I cannot delete the table because of existing relationships.

So, I'm looking for some code to record the relationships that a particular
table has, then drop, then reestablish them after I have relinked the list.

Any ideas?
--
HTH
Dale

Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.
 

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