Accessing access database

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

HI,

how can I write to an access database on my pocket pc? doesn't seem possible
to me with the .net compact framework - and I cannot afford any commercial
solutions (as inthehands.com). Is there any other way?

Or, even better, is there any way to avoid pocket pc access databases?
All I need to do is to write records to a file/database that need to be
automatically inserted/added to an existing (desktop) Access database (*.mdb)
on the desktop computer, when I initiate an ActiveSync.

Thanks for any helps or hints,

Peter
 
You can do what Peter did in his library yourself. How much time are you
willing to apply to this (how much value does your time have)?

As far as I can think, unless you write a RAPI program to run on the desktop
when the device is attached with ActiveSync, that downloads a text file and
does your updates to Access, build a Pocket Access database is the only way.
If records are only added, never modified, and never removed, maybe it's not
so tough to do this. That's application dependent.

Paul T.
 
Replication/RDA to an MSDE database on the desktop, then a DTS export to
Access would also work, though I'd hate to have to do the install or
maintenance on something like that.

-Chris
 
I'm working on something like this. It accesses cdb databases through a
managed CEDB interface. This will be published soon as an article and
*maybe* as a commercial library. Please contact me through my site's contact
email address at www.primeworks.pt
 
Thanks for replying to everybody!

All I want to do is to INSERT records into one specific table. If this
cannot be solved with .net code - is it possible to do this with a C++ DLL on
the pocket pc? what do I need to create such a dll? Can I use a desktop Dll?

Lots of questions:)

Peter
 
My approach uses a small C++ DLL and .NET code. It is also possible to
access these databases from the desktop using RAPI.
 
Back
Top