Re: [mdb-dev] Write Support - Port or write?

[Brian B. <br...@br...>]

I looked at Jackcess some time ago with the intention of figuring out
what they knew about updates that we didn't.

A comment on the current state of MDB Tools and writing (at least as
of the last time I worked on it).  It is possible (or at least was,
I'm suspecting I mismanaged some code and lost my last changes.
Nevertheless they where not extensive) to use mdb-import to write rows
into a table and them read them back successfully using MDB Tools.
What doesn't work is reading them back with Access.  This indicates
that the problem lies in our updating of allocation maps, indexes, or
some other meta-data which understanding the Jackcess code would
hopefully illuminate.  I don't think directly porting would be very
worthwhile.  Also, once we do get it working we need to added
INSERT/UPDATE to the SQL engine (and by extension the ODBC driver),
etc.

My 2 cents...

2011/2/7 Houston, Dion A Sr CPT MIL USA OSD <dio...@us...>:
> Hi all,
> Once again, I'm looking at this project to add to the GDAL project to
> import/export files in a MDB compatible format.  In desiring to make it as
> open as possible, I don't intend to use Jet.
> As we all know, write support is currently only partially supported in the
> source.  I am aware of another MDB library which does support writing called
> Jackcess, http://jackcess.sourceforge.net/ .  I am neither proficient in
> Java, nor highly knowledgeable on the Jet database format (although I did
> use to work in the group).  It seems like there are two main options:
> - Figure out the write code, possibly using Jackcess and incorporate it into
> MDB Tools
> - Port Jackcess to C++
> Based on collective experience of the group, does anyone have any analysis
> or recommendations of what would be easier?  I looked over the Java source
> and it doesn't seem too complicated, but I don't know what I don't know
> about porting Java.  On the other hand, I don't really know where to begin
> on adding write support to MDB Tools, but I am highly comfortable with
> C/C++.
> Thanks in advance for any wisdom you can impart…
> Dion
> ------------------------------------------------------------------------------
> The modern datacenter depends on network connectivity to access resources
> and provide services. The best practices for maximizing a physical server's
> connectivity to a physical network are well understood - see how these
> rules translate into the virtual world?
> http://p.sf.net/sfu/oracle-sfdevnlfb
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>
>