Hi folks, I talked with Gene today by phone. He would like to use Gears under the following scenario; I told him there might be concurrency issues but I wanted to see if anyone else in the community had tried this:
Gene's users have a local MS Access database on the users desktop; they manipulate this through MS Access. Gene would like to have some of the tables be live and also change the SQLite database that Gears would be using. Has anyone tried something like this? Some questions for Gene: * Do you want two-way access? I.e., does the user through the web-browser ever change SQLite in such a way that it would need to propagate to Access, or are things read-only from the web side? * What technologies do you plan to do the synchronization between the Gears SQLite database and the Access database? JavaScript running inside the browser won't work. SQLite is a single process database, so my understanding is it won't work in this scenario. On Thu, Sep 25, 2008 at 12:54 PM, gene <[EMAIL PROTECTED]> wrote: > > Using SQL lite the need is to be able to have live interaction with a > MS Access database on the users desktop. The Access database can be > converted to SQL if it makes the job doable. there are only six tables > from the Access database that need to be moved into the SQL lite. Is > this impossible? > > Thanks > -- Best, Brad [EMAIL PROTECTED]
