I have a software application with an Access front end and an Access backend
to house the data. Recently I converted the backend to MySQL. The Access
frontend works fine connecting to the MySQL backend.
The issue I have now is that I also have a syncronized database on a PDA. I
was using ActiveSync and Pocket Access to create the database on the PDA and
keep it syncronized with my PC (backend) database. I'm using eVB programs
to retrieve and update the data on the PDA, then all I have to do is sync
the PDA with ActiveSync and it will update my Access Backend database
accordingly and vise-versa.
I know MySQL doesn't have a PDA client, but I was wondering if anyone knew
of a third party application that I might be able to use to create and sync
a database on the PDA with the MySQL database on the PC.
If that is not an option, on the PC side, I could keep a
replicated/synchronized Access database using a third party app (like
Access2MySQL Sync). I would still keep the MySQL backend, but also have a
replicated/syncronized Access database strictly for use with my PDA. This
would allow me to keep my ActiveSync & Pocket Access synchronization
process. My problem is I can't find a third party app that actually works
well enough to put into a production environment. Does anyone have any
recommendations or suggestions? Thank you.
to house the data. Recently I converted the backend to MySQL. The Access
frontend works fine connecting to the MySQL backend.
The issue I have now is that I also have a syncronized database on a PDA. I
was using ActiveSync and Pocket Access to create the database on the PDA and
keep it syncronized with my PC (backend) database. I'm using eVB programs
to retrieve and update the data on the PDA, then all I have to do is sync
the PDA with ActiveSync and it will update my Access Backend database
accordingly and vise-versa.
I know MySQL doesn't have a PDA client, but I was wondering if anyone knew
of a third party application that I might be able to use to create and sync
a database on the PDA with the MySQL database on the PC.
If that is not an option, on the PC side, I could keep a
replicated/synchronized Access database using a third party app (like
Access2MySQL Sync). I would still keep the MySQL backend, but also have a
replicated/syncronized Access database strictly for use with my PDA. This
would allow me to keep my ActiveSync & Pocket Access synchronization
process. My problem is I can't find a third party app that actually works
well enough to put into a production environment. Does anyone have any
recommendations or suggestions? Thank you.