Hi there,
this is my first ever post on a forum so please be nice if i get stuff wrong.
I am wanting to develop an application for a Windows Mobile 5.0 device using visual studio 2005 but i want to store data on the device using pocket access.
Can anyone tell me if this is possible or whether i am 'forced' to use SQLserver
The reason i use the word "forced" is that all our software is written in vb6 and stores data using MS Access. The application i am wanting to develop needs to ultimately merge the data with the existing ms access databases. (There are only a limited number of people access these databases so i dont feel any need to upgrade to SQL just yet - If it aint broke dont fix it!!!!)
I've found threads that say you could get a .net ADOCE wrapper but also found threads that say this is not supported by windows 5.0 & 5.0 emulator
If anyone can help i would be very grateful as i keep going round in circles.
Cheers
Darren
Pocket pc application using Access 2003
Plateau
thanks again, at least i know now we dont have to rewrite the entire company software just to incorporate the 1 handheld device.
Cheers
Darren
DotNetSavvy
The common knowledge in the Windows Mobile community is that ADOCE has been deprecated and is not supported in Windows Mobile 5.0. My understanding is that you can install the DLLs and ADOCE will work with ActiveSync 4.0 but once again this is not supported. Microsoft was apparently working on an (unsupported) patch for this but provided no timetable.
About the only other comment I can offer is that this setup is unsupported.
The following links may provide a little more info:
http://tinyurl.com/zttfa
http://www.pocketpcmag.com/FORUM/topic.asp TOPIC_ID=22264
david.r.johnson
The following may be of interest:
http://blogs.msdn.com/sqlmobile/archive/2006/06/01/612768.aspx
http://www.primeworks-mobile.com/
Rick Hodder
Thank you Paul,
was really hoping someone would say "oh yes here's the link for the patch you need, and i've attached a few code samples to help!". (in my dreams!). You've pretty much confirmed for me what i I've spent days scouring sites and forums for.
I dont suppose you know if theres a way of converting SQLserver files to Access.mdb files
strategy No2:
a)Create the Mobile application to store data in SQL
b)transfer to a temp file on PC
c)convert to Access.mdb
d)merge with existing Data
Thanks again for your help, much appreciated.
Someone said a pessimist is just an experienced optimist!