On 6/28/05, Dave Watts <[EMAIL PROTECTED]> wrote: > > One fundamental question is why use Access on the tablet? MySQL is > > available under the GPL, so unless you're needing a commercial license > > you should be fine. That would save an *enormous* amount of pain in > > the back/forth conversion. > > Or, better yet, run MS SQL Server on the network and MSDE on the desktop, > and just use its built-in synchronization functionality. I've been working a > bit with something similar lately (SQL Server CE on Windows Mobile for the > client) and it seems to work pretty well. You can probably buy a > single-processor MS SQL Server license with the money you save by not > writing the code you'd otherwise need.
Righto -- that's an excellent solution as well. Sort of depends on whether MySQL on the server is necessary or not. MSDE and MS-SQL play great together. Of course, you'll need to verify the MSDE licensing -- if memory serves, you have to have licensed one of a large number of MS products (including Access, I believe). And then there's the whole SQL Server 2005 Express (aka MSDE 2005) vs. MSDE to consider. Oh -- and of course your server has to run Windows :) And to make the options complete (and depending on the load on the server) you *could* just run Access everywhere, tablet and server -- but you'd have definite performance limitations and you wouldn't be able to sync without writing some code. I think the point that Dave and I are both making is that it will be expensive (and probably unneccessary) to support two different databases when there are options to keep everything on one db platform. -- John Paul Ashenfelter CTO/Transitionpoint (blog) http://www.ashenfelter.com (email) [EMAIL PROTECTED] ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:210703 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54