[mdb-dev] SQL problem

[Jonathan D. <dix...@ly...>]

I'm having a little problem reading information from various tables in on=
e of my MDB files (the main one I work with).

I started out having a problem with reading one of the tables in a databa=
se of mine using mdb-sql from the command line (or using any number of ot=
her means through mdbtools). Since there have been a number of recent pat=
ches posted to the CVS archive, I went ahead and downloaded those and rec=
ompiled mdbtools to see if that would fix the problem.

Well I can read that table now, but the others that worked before no long=
er work. A "Select * from Ranks" query (or whatever table I want to use) =
will pick up the columns for that table but will not retrieve any rows (w=
hich is what happened on the one table before).

I can read the same database through ADO and OpenOffice on my Windows mac=
hine and all of the info in the various tables is indeed there, so it doe=
sn't appear to be the file itself.  Unfortunately the MDB file is fairly =
large and contains private information, so I cannot forward it along to a=
ssist in the debugging.  I am running Fedora Core 2 on an Intel machine. =
Is there something that changed in the recent revisions that might explai=
n this behavior? Are there things I can check in the file to assist in th=
e debugging? And most importantly, does anyone have any ideas for how I c=
an actually read all the columns in my database?

Thanks for your help,

Jon Dixon
dix...@ly...
http://dixonjon.tripod.com/


--=20
_______________________________________________
Find what you are looking for with the Lycos Yellow Pages
http://r.lycos.com/r/yp_emailfooter/http://yellowpages.lycos.com/default.=
asp?SRC=3Dlycos10