Accessing access database

[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

 

[Paul G. Tobey [eMVP]]

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.

 

[Guest]

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

 

[João Paulo Figueira [eMVP]]

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

 

[Guest]

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

 

[João Paulo Figueira [eMVP]]

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