are there numbers assigned to each data type?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

it seems that instead of creating a schema.ini file a programmer created an
export specification table. I don't know a lot about anything to do with
access and I am having problems with my exporting function. My question what
numbers are assigned to data types? Example is 12 - Memo, 10 - text, etc? I
need to know because I think a data type has changed in my table and I have
to change it in the export spec table too, I know which field to change but
not what type to change it to. I hope this makes sense - I can provide more
info if needed. Please respond.
 
You can find the values of the members of the ADO and/or DAO DataTypeEnum in
the Object Browser.

In the VBA editor, select Object Browser from the View menu (or use the
keyboard shortcut F2).

If your app is using ADO, select ADODB from the first drop-down list in the
top left corner of the Object Browser. If your app is using DAO, select DAO
from the list instead. Both the ADODB and DAO object libraries have members
called DataTypeEnum, so which ever library you chose, find this member in
the 'Classes' list.

When you select DataTypeEnum from the Classes list, the larger list to the
right will be updated to show the members of that class. Select any member
in the list and the status panel across the bottom of the Object Browser
will display information about the selected member.

It looks as though the numbers you are seeing may be the values of the DAO
DataTypeEnum members, as the value of the dbMemo member is 12, and the value
of the dbText member is 10, as in your example.
 
Back
Top