User Defined Data Type

[doodle]

Greetings. SQL 2k5, Access 97 (I know)

If I create User Defined data types in SQL, and relink my SQL tables
in the database, will Access still be able to read those data types?

For instance: for State I currently have Char(2) in SQL. If I open the
linked SQL table in access, it shows Access reading the data type as
Text.

I would like to create a user defined data type tState as Char(2). If
I do that, will access still bring in as 'Text'? I am especially
concerned about this working with Access 97.

thanks for your help,

-doodle

 

[storrboy]

Char(2) would be Text limited to 2 characters isn't it?
If so a Text field in Access contains a 'FieldSize' property which
does the same.

 

[Allen Browne]

For a comparison of the names used in Access (JET) with the field names you
use in DDL, see:
Field type reference - names and values for DDL, DAO, and ADOX
at:
http://allenbrowne.com/ser-49.html

The ADOX names are probably closest to the SQL Server names.