Dear Google, Thank you for looking at my issue. In-line are the answers to your response questions. -- Thanks, Gene
From: Brad Neuberg <[EMAIL PROTECTED]> Reply-To: <[email protected]> Date: Thu, 25 Sep 2008 14:08:49 -0700 To: <[email protected]> Cc: Scott Hess <[EMAIL PROTECTED]> Subject: [gears-users] Re: Reading data from MS Access-concurrence the problem 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? No, the communication is one-way. * 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. We are wide open to suggestions. Access can run a SQL database which may make the process easier. SQLite is a single process database, so my understanding is it won't work in this scenario. Is there any other way to ³milk this cow?² 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]
