471,573 Members | 1,327 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,573 software developers and data experts.

Synchronize Access Database onto PDA

173 100+
Hi All,

I'm starting a new project and need some help...

I would like to update a main database file on a PC using PDAs. The PDA will contain the replica file and any changes made by workers on the PDA will sync to the PC file.....

The hard bit, i would like this to be done wirelessly or possibly through bluetooth and done instantly.... using windows mobile...

I would like to know if this can be done? if so, how and what equipment is required?

all help will be appreciated many thanks
Dec 22 '08 #1
8 3605
32,439 Expert Mod 16PB
I think you will probably find more appropriate expertise in the Mobile Development Forum, so I've moved this for you.

Good luck with your project :)

PS. Adjusted title to give the Mobile Experts a better understanding of where you're coming from.
Dec 22 '08 #2
173 100+
anyone? I need serious advice ;)
Dec 23 '08 #3
32,439 Expert Mod 16PB
I'm afraid that not all forums are as well populated or as busy as Access is (only .NET comes close). I will see if I can drum up some interest in the general Expert area.
Dec 23 '08 #4
Curtis Rutland
3,256 Expert 2GB
How about exposing a web service that can modify the access database, and letting your WinMo program connect to that?
Dec 23 '08 #5
7,872 Expert 4TB
Its my belief that data syncronizing is always a huge pain.
InsertAlias may have the best solution as far as connectivity over wireless.
Being able to handle webpages/etc is a pretty standard ability on devices. The bonus of a webservice is you can use a webpage to communicate with it, or software like a windows application.

Bluetooth requires such a close proximity that you might as well be connected with a usb cable and use ActiveSync to sync.
Dec 23 '08 #6
Curtis Rutland
3,256 Expert 2GB
Yeah, think of the web service as an online class library that any client can use.

The best thing about this is that if your PDAs have internet access, they don't have to store a changelog, they can update the source DB itself.
Dec 23 '08 #7
9,735 Expert Mod 8TB
Hmmm.....the OP is going to need to host the synchronizing methods on a web server if they implement the web services solution...They'd have to turn the computer into a web server. This seems to be a bit overkill for what is required. There has to be a better way to do this....mind you I can't think of one off the top of my head.

>>subscribing because I'm curious<<
Dec 23 '08 #8
9,735 Expert Mod 8TB
Hmm after poking around I found that ActiveSync will synchronize your pocket PC's Access with your PC's access....however wirelessly doing this seems to have been discontinued because the data being transferred was unencrypted.

I think I saw some mention that this can be done via Bluetooth but the range is limited... I'm not 100% on it though, especially since the MSDN article doesn't mention Bluetooth support at all.
Dec 23 '08 #9

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by gene.ellis | last post: by
reply views Thread by Radek Mrkvicka | last post: by
1 post views Thread by taleran58 | last post: by
1 post views Thread by taleran58 | last post: by
3 posts views Thread by Elioth | last post: by
1 post views Thread by John | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by Vinnie | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.