Taking some SharePoint tables offline only, not all

[Jan van Bekkum]

I use MS Access 2007 and SharePoint 2007.

I have designed a database that is shared in our group. I am using SharePoint to share the tables. Some tables I would like to keep always online. For performance reasons I would like to take other tables offline and synchronize them from time to time only. Is it possible to take only some SharePoint tables offline, not all?

An alternative solution to the problem would be if I can automatically synchronize foreign keys after private keys change when SharePoint comes back online. I haven't found a way to do so. Is there any way to do so?

Thanks a lot in advance.

 

[dfenton]

I'm not a user of Sharepoint, but it seems to me the difference would be between linking to a Sharepoint list, and linking to a database stored in Sharepoint. But I'm foggy on the differences!