Re: MS Access Database Connectivity For Win CE 6.0

MS Access is a desktop only database format. There was a very basic companion format called Pocket Access support for which ended with Pocket PC 2003. There are ways of synchronizing Access with a supported device database format (such as SQL Mobile) in the Access Database Synchronizer:-
http://www.microsoft.com/downloads/details.aspx?FamilyID=b967347a-5dd0-445c-8a9f-aea3db9ec4bc&DisplayLang=en

You can then work with the data through the System.Data.SqlServerCe namespace. Alternatively if you want to work with a server machine running an Access database you'd need to implement a Web Services or Sockets server which internally used OleDb and the full framework.

Peter

--
Peter Foot
Microsoft Device Application Development MVP
www.peterfoot.net | www.inthehand.com
In The Hand Ltd - .NET Solutions for Mobility

"Arsalan" <Arsalan@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:17027AE3-08A5-4833-A82A-729BF0D4F51A@xxxxxxxxxxxxxxxx
Hello guys,

I want to connect to and edit ms access database. The oledb functionality is
not present for .NET CF. When I try to build the solution, it gives me an
error "are you missing an assembly reference?" PS. I am coding in C#

I would like to know if there is a way to connect ms access database, and if
there is a way then what is it?

If not, then how should I go about dealing with this problem?


A little info on my project - I am doing a vending machine project for my
senior design where I have to take out all the logic circuit and replace it
with some thing new. I am using EBOX 2300 as the main control board, which
will have signals coming in and out to control other modules of the project.
The database is for keeping pricing information, authorized user information
such as user name and password (we are implementing student id and rfid card
purchases), and other things.

.

Relevant Pages

  • Re: Circular Reference - cannot locate
    ... Save As to a database format such as Access or MPD. ... If your project is stored on Project Server, then perform steps 3 and 4 ... task has no successors so I cannot see how it is leading back to itself ...
    (microsoft.public.project)
  • Re: s10_55 installation (upgrade) problems
    ... >> It seems that the old database format works better for me. ... > package database was always in the old format, ... patches. ...
    (comp.unix.solaris)
  • Re: Unrecognized Database format - how could this be??
    ... Although ".mdb" is the "native database format" used by Access, in fact Access is really a "front end" that lets you develop forms, reports and so on. ... Even if you have Access, it's better not to open these OALs in Access, e.g. to do reporting,because Access may change the database structure so that Word no longer recognises them as OALs. ...
    (microsoft.public.word.mailmerge.fields)
  • Re: NDS-Fehler
    ... Repairing Local Database ... ERROR: Insufficient disk space or missing files, ... The database format is invalid. ...
    (de.comp.sys.novell)
  • Re: Access 97 AND Access 2000
    ... and queries). ... Access 97 predates the Access 2000 database format and ... If you split your database, you can have two versions of the front end, ...
    (microsoft.public.access.conversion)
Loading