"Peter Foot [MVP]" <feedback@nospam-inthehand.com> wrote in message
news:BFECA2C4-7749-418F-901A-81DB2713B1EB@microsoft.com...
> 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@discussions.microsoft.com> wrote in message
> news:17027AE3-08A5-4833-A82A-729BF0D4F51A@microsoft.com...
>> 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.
>

"Arsalan" <Arsalan@discussions.microsoft.com> wrote in message
news:79DC62A4-34FC-4CB4-B881-52C595FAC53A@microsoft.com...
> Thanks for your reply Peter.
>
> I am using EBOX, which is a mini computer with a 200 MHz processor. The
> Access database will be on the EBOX it self and the EBOX will be a server
> as
> well. Any changes made to the database can be done through a website,
> which
> my team member is developing. He knows ASP programming and wants to stick
> with MS Access. I don't know if I used SQL server, would the programming
> for
> the website be any different. I guess that is the reason he wants to stick
> with it, and anyways we don't want to install two servers on the EBOX, as
> it
> will slow it down.
>
> I also don't know anything about Web Services or Sockets server. I am just
> a
> senior electrical engineering student, trying to do my senior design
> project,
> lol.
>
> Are there any OLEDB providers or wrappers made by people to handle this
> functionality in .NET CF?
>
> Thanks
>
>
>
> The thing is that I want to stick with MS Access because my team member is
> developing a website