[mdb-dev] table problem , data wrong type

[Barry A. T. <ti...@ms...>]

I have an apparent problem with an access db.
One of the tables appears to have incorrect
data type detection.

mdb-sql reports the following description of a table
in my database. The EmployeeID is supposed to be
a 50 character string, but it shows up as a date.
The ExpirationDate is supposed to be a short date,
but shows up as a memo/hyperlink.

The CardNumber shows up as a 2 byte interger, but
the text lengths appear to be 2X the size reported
in MS OFfice 2003 Access. I understand this may be
due to Office using 2 byte character representations ?

I am using the current version(0.5_6) of MDBTools running
on FreeBSD 5.4 .

+------------------------------+--------------------+----------+
|Column Name                   |Type                |Size      |
+------------------------------+--------------------+----------+
|CardNumber                    |Integer             |2         |
|PIN                           |Text                |24        |
|EmployeeID                    |DateTime (Short)    |8         |
|DateAssigned                  |DateTime (Short)    |8         |
|DateReturned                  |DateTime (Short)    |8         |
|ExpirationDate                |Memo/Hyperlink      |0         |
|Notes                         |Text                |100       |
|Email                         |Text                |8         |
+------------------------------+--------------------+----------+

-- 
Barry A. Tigner
Electronics Shop Mgr.
Physics and Astronomy dept.
Michigan State University
ti...@ms...
517-355-9200 x 2538
room 1223 Biomedical Physical Sciences bldg.