Temporary table solution for web db
Posted on 2011-09-08
I have created a hybrid Access application, but have the need for a temporary (local) table to exist in each users copy. This table will be used to allow each user to play some "what if" scenarios. By "hybrid Access application", I am talking about an Access application that has been published to SharePoint, but each user runs an Access file locally with the data being stored on SharePoint. This works very nicely allowing users to use native forms instead of dealing with the browser limitations.