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
8  3794  NeoPa 32,579
Recognized Expert Moderator MVP
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.
anyone? I need serious advice ;)
NeoPa 32,579
Recognized Expert Moderator MVP
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.
How about exposing a web service that can modify the access database, and letting your WinMo program connect to that?
Plater 7,872
Recognized Expert Expert
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.
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.
Frinavale 9,735
Recognized Expert Moderator Expert
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<<
Frinavale 9,735
Recognized Expert Moderator Expert
Hmm after poking around I found that ActiveSync will synchronize your pocket PC's Access with your PC's access....howev er 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.
Sign in to post your reply or Sign up for a free account.
Similar topics | |
by: gene.ellis |
last post by:
Using a web interface, I am placing text into a SQL database. From time
to time, I would like to synchronize one of my other tables in the
database with the table that I am inserting content into. What is the
SQL command to synchronize these tables? I will be initiating this
command through a web interface, so I cannot use enterprise manager.
Thank you very much!
|
by: Lee Rouse |
last post by:
Hello all,
This is going to be a rather lengthy "question".
I have an Access 2k database, separated front end/back end. Front end
copies are on about 30 workstations and used frequently during the
work day. The backend has a table called CLIENTS with approximately
6000 client records. Changes to data in the table are made via a
frontend db Form which has CLIENTS as its record source.
|
by: Zlatko Matiæ |
last post by:
There is a form (single form) and a combobox. I want that current record of
the form is adjusted according to selected value in the combobox. Cuurrent
record should be the same as the value in the combobox.
What is the solution?
Thank you in advance.
|
by: Radek Mrkvicka |
last post by:
GeniusConnect for Microsoft Outlook® 2000/XP/2003
Synchronize Outlook® data with any DB2 database!
You can synchronize Outlook data with any relational database that supports
ODBC (DB2, MS Access, MySQL, SQL Server, Oracle etc.).
With GeniusConnect, you can export your Microsoft® Outlook® data to a
database and also load data from the database into a Microsoft® Outlook®
|
by: taleran58 |
last post by:
Hi all.
I'm writting a multithreading program that will update a loacal Access
database.
I'm using OleDB connection to get access to the database from each
thread and my question is: how do I synchronize between threads\ how do
I lock the database so no clashes between threads occurs.
do I have to use a diffrent connection\adapters???
| | |
by: taleran58 |
last post by:
Hi all.
I'm writting a multithreading program that will update a loacal Access
database.
I'm using OleDB connection to get access to the database from each
thread and my question is: how do I synchronize between threads\ how do
I lock the database so no clashes between threads occurs.
do I have to use a diffrent connection\adapters???
|
by: Elioth |
last post by:
Hi,
I want to synchronize Access and SQL database schema.
I have running a application and I want sync database because when I create
a new Table in the database I need this table in all client database. At this
moment I create a Table manually in each database client.
Thanks for all help.
Elioth
|
by: John |
last post by:
Hello,
I need to synchronize one access database with other access database. Tables
and fields are off course same.
Can someone tell me how to achieve this?
Regards
|
by: raylopez99 |
last post by:
10 years ago, the below was written (see very end, after my signature
RL).
What, if anything, has changed?
I have Access 2003 and soon Access 2007 on a Windows XP Professional
or Windows Vista Ultimate machine, with SQL Server Express running on
it, and I want somebody, with a password (which I will provide) to be
able to log onto a A03 or A07 dB from the internet. Now that I type
this I realize that unless I put the database onto a...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed.
This is as boiled down as I can make it.
Here is my compilation command:
g++-12 -std=c++20 -Wnarrowing bit_field.cpp
Here is the code in...
| | |
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
