Home > IT Answers > Mobile > Mobil 5.0 open an MS Access database
Mcknightd
15 pts.
 Mobil 5.0 open an MS Access database
Mobile data systems, Mobile devices, Visual Basic, Visual Basic developers, VS 2005, Wireless
Can someone who has used a Mobil5.0 application to open,modify a MS Access Database. Would you share how you did this? I'm fairly new to VS2005. I have a application that communicates with a text file but would really like it to use a database instead.

Software/Hardware used:
ASKED: February 4, 2008  2:31 PM
UPDATED: February 6, 2008  3:18 PM
RELATED QUESTIONS
Answer Wiki:
Try SqlServerCE 2.0 or 3.0! any one of those. it is very easy to deploy and mantain rather than MS Access Database on Pocket PC and PDA,EDAs etc. Couple of years ago, I tried MS Access but i faced so many problems in my program. so I preferred SQLSERVER Compact Edition. builtin with VS 2005. Just add a reference System.Data.SqlServerCe in you application and Enjoy the DBMS. M4atiq
Last Wiki Answer Submitted:  February 6, 2008  7:14 am  by  M4atiq   100 pts.
All Answer Wiki Contributors:  M4atiq   100 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

I am assume this is something I have to install on each handheld? Then could I use SQL Lite on a shared computer?

What about MySQL on a shared computer?

Why all this sharing? I have many handhelds that need to modify, create, and view information wirelessly. Right now I can do that, but in a text file. I was hoping for a way to use MS Access databse. It’s the only corporate approve database for employee use. uhhhggg

Thanks for the answer! It gives me an option maybe. Any thoughts? Maybe I need to approach this from another view point. I don’t know, like I said I fairl new to VS2005 and Mobil5.0. Using CE I’m able to connect just fine to a MS Access database no problem.

Mcknightd
 15 pts.