Hi Gene, by one-way, do you mean that the SQLite instance inside of Gears would only be reading the data that would be generated by Access? Also, what do you mean by "SQL Mode" for Access? I'm not familiar with Access.
On Thu, Sep 25, 2008 at 2:31 PM, Gene Velazquez <[EMAIL PROTECTED]> wrote: > 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] > > -- Best, Brad [EMAIL PROTECTED]
