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.
View Complete Post