Home > IT Answers > Development > Mobil 5.0 open an MS Access database
Help

Question

  Asked: Feb 4 2008   2:31 PM GMT
  Asked by: Mcknightd

Mobil 5.0 open an MS Access database


VS 2005, Mobile data systems, Mobile devices, Visual Basic developers, Visual Basic, 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.

Subscribe to Alerts! Get questions and answers delivered to your Inbox.


E-mail me updates on this question



   SUBSCRIBE

hidden modal window
Help

Answer Wiki (Improve, edit or add to this answer)

IMPROVE THIS ANSWER
View History
 RATE THIS ANSWER
+1
Click to Vote:
  •   1
  •  0
Last Answered: Feb 6 2008  7:14 AM GMT  by M4atiq




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
  • AddThis Social Bookmark Button

Browse more Questions and Answers on Development, Mobile and Networking.

Looking for relevant Development Whitepapers? Visit the SearchSQLServer.com Research Library.


RSS - Discussions Help

Discuss This Answer


You must be logged-in to discuss a question. Log-in/Register

Mcknightd  |   Feb 6 2008  3:18PM GMT

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.