Dear Brad, Yes, the SQL lite would only be reading. MS Access can be run off a SQL database. The customer would allow be to convert to SQL. -- Thanks, Gene
From: Brad Neuberg <[EMAIL PROTECTED]> Reply-To: <[email protected]> Date: Thu, 25 Sep 2008 14:48:42 -0700 To: <[email protected]> Cc: Scott Hess <[EMAIL PROTECTED]> Subject: [gears-users] Re: Reading data from MS Access-concurrence the problem 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]
