Re: [mdb-dev] Column names getting cut off

[Sam M. <pa...@gm...>]

Tried repairing your access database using the access repair utility?

access databases are remarkably fragile - they're the only databases
i've needed to use repair facility on a semi-regular occaision.

Sam

On Thu, 24 Feb 2005 10:52:46 -0600, Camden Daily <cd...@gm...> wrote:
> Hello list.  For a project I'm developing I need to access a live mdb
> database to pull some data and utilize it in a php app on a linux box.
>  Since the data need to be 'live', I can't simply export the mdb to
> another format; I have to access it as an mdb.
> 
> Currently, I'm trying to use mdbtools, mdbtools-odbc, and unixodbc.
> I've tried using the rpms for version 0.5-1 and 0.5-236 of the
> mdbtools packages, and version 2.2.8-55 of unixodbc.
> 
> Everything installs fine, and I can connect to my mdb just fine.  The
> mdb is Jet 4 and about 200 megs large, and contains a few dozen
> tables.  I can access most of the tables just fine.  However, the one
> that I actually need doesn't come through correctly.  When I use
> mdb-sql to do a 'describe table' on it, about the first 20 columns
> come through find, but then the next 80 or so columns are completely
> blank.  The one between the ones that work and ones that don't is cut
> off, with only half the column name showing up.  The ones with blank
> column names still have their type and size displayed correctly, so
> it's kind of being read correctly.
> 
> I've looked at the table in Access, and nothing seems very strange
> about that particular column.  My tables and column names do contain
> underscores, but as it works with other tables that have underscores,
> I don't think that's the issue.  I tried the 'compact and repair
> database' option in Access as well, but that didn't fix it.
> 
> I tried compiling the 0.6 version of mdbtools, but it can't read any
> of the tables in my database.  I tried the cvs version as well, but
> couldn't get it to even compile correctly.
> 
> Any help would be greatly appreciated.
> -Camden Daily
> 
> -------------------------------------------------------
> SF email is sponsored by - The IT Product Guide
> Read honest & candid reviews on hundreds of IT Products from real users.
> Discover which products truly live up to the hype. Start reading now.
> http://ads.osdn.com/?ad_id=6595&alloc_id=14396&op=click
> _______________________________________________
> mdbtools-dev mailing list
> mdb...@li...
> https://lists.sourceforge.net/lists/listinfo/mdbtools-dev
>