Remote Database and Office Database
in [General]
|
Prev: Douglas Steele, Arvin Meyer, Tony Toews, John Spencer, DuaneHookum, Allen Browne, etc
Next: Update prices in access from Excell
From: Thomas Kroljic on 26 May 2010 14:41 Hello, My boss would like to have several of his field employees (9) have an Access application on there laptop/netbook device so when they visit customers, they can input data into the database. They will not have access to the internet or any type of Remote connection. This will be a stand-alone Access application on their laptop. ( Field person will meet with 10 customer a day.) My two questions have to do with when the field employees come back into the office. What will be the best way to a) get data from their version of the database on their laptop into the Office database? a) Should I user Replication Manager or b) would it be easier in the long run to write (vba) code to move the data between the laptop database and the Office database? If this is the route to take, how would I connect (using vba code) from the Field version of the database to the Office version? or c) export the appropriate data to a separate file? For some reason, I'm thinking if I can steer clear of the Replication Manager, I'll have fewer headaches. Is this true? And my second question would have to do with any changes that I would need to make to the data structure. How do I update the Field databases? Again, would it be better to write the vba code to modify the data sturctures instead of using Replication Manager? I envision very few changes to the database sturcture. But I can see forms, reports, queries... being added or updated. Thank you, Timothy
From: Thomas Kroljic on 26 May 2010 19:28 Is this the right forum to post this message? "Thomas Kroljic" <tkroljic(a)covad.net> wrote in message news:uVjhcMQ$KHA.1448(a)TK2MSFTNGP06.phx.gbl... > Hello, > > My boss would like to have several of his field employees (9) have an > Access application > on there laptop/netbook device so when they visit customers, they can > input data > into the database. They will not have access to the internet or any type > of > Remote connection. This will be a stand-alone Access application on > their laptop. ( Field person will meet with 10 customer a day.) > > My two questions have to do with when the field employees come back into > the office. > What will be the best way to a) get data from their version of the > database on their > laptop into the Office database? > a) Should I user Replication Manager > or > b) would it be easier in the long run to write (vba) > code to move the data between the > laptop database and the Office database? If this is > the route to take, how > would I connect (using vba code) from the Field > version of the database > to the Office version? > or > c) export the appropriate data to a separate file? > > For some reason, I'm thinking if I can steer clear of the Replication > Manager, I'll have fewer headaches. Is this true? > > And my second question would have to do with any changes that I would need > to make to the data structure. How do I update the Field databases? Again, > would it be better to write the vba code to modify the data sturctures > instead of using Replication Manager? > > I envision very few changes to the database sturcture. But I can see > forms, reports, queries... being added or updated. > > Thank you, > Timothy > > >
From: PieterLinden via AccessMonster.com on 26 May 2010 20:06 Thomas Kroljic wrote: >Is this the right forum to post this message? > >> Hello, >> >[quoted text clipped - 37 lines] >> Thank you, >> Timothy David Fenton must be busy... dig around for his website. He'll know. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access/201005/1
From: John W. Vinson on 27 May 2010 11:48 On Thu, 27 May 2010 08:39:46 -0400, "Thomas Kroljic" <tkroljic(a)covad.net> wrote: >John and Pieter, > > Thanks for the tip. Is Replication stable? The last time attemtpted to >use it was 8 years ago. At that time it seem like a pain-in-the-butt...in >the end, we ended up using Terminal Services. Unfortunately, I don't have >that option at the moment. > I'll check on David Fenton in the group you listed below. It's stable, it does the job, it's a pain in the butt, and it's complicated to set it up correctly. I've used it with two clients and they both ended up using Citrix (terminal services basically). It is possible to "roll your own" replication as you suggest, but it's a VERY complicated and difficult process; you wouldn't be reinventing the wheel, more like reinventing an automatic transmission! -- John W. Vinson [MVP]
From: David W. Fenton on 27 May 2010 13:17
"Thomas Kroljic" <tkroljic(a)covad.net> wrote in news:u6ulmsS$KHA.5476(a)TK2MSFTNGP06.phx.gbl: > Is this the right forum to post this message? How is this inappropriate? -- David W. Fenton http://www.dfenton.com/ usenet at dfenton dot com http://www.dfenton.com/DFA/ |