Accessing a MS Access 2003 DB from .NET CF v2.0 app running on WM2

[Guest]

I'm new to .NET so I appologize in advance if this question is simple.

Background -->> We're building a proof of concept application on Windows
Mobile 2003 based barcode scanner which needs to look up records in our MS
Access 2003 database and display the results based on scanned barcode. By
the way, the connection is Wi-Fi and it works pretty good so far.

Question -->> We need to query Access 2003 and not sure how best to
accomplish this. Web services has already been ruled out, so we need a way
to directly query Access from .NET CF v2.0. It is preferred that the scanner
be able to submit the requests directly to the DB and not use any additional
software which would have to sit on a PC and act as a proxy to the data.
Will Access support direct SQL statements like a SQL Server database might??
Any ideas or example code??

 

[Guest]

You can't make a direct call to the DB - there's no provider for it. You'll
have to write some intermediary service that will essentially do what the
Web Service you've ruled out would do.

-Chris

 

[Pete Vickers [MVP]]

Hi,
take a look at SqlLinkCE on our site - we do that already

Pete