TransferDatabase in Access 2002 fails to generate varchar fields on SQL Anywhere

[Muravenn]

Hi,

I've just discovered the forums and I have a question
that is related to MS Access 2002/SQL Anywhere/SQL Server.

We are using Access to create a Sybase SQL Anywhere 5.5
database from a MS SQL Server 8.0 database.
So therefore, MS Access 2002 is used. In the process, we
are using the TransferDatabase method of Access.
So the command is like this '
<
DoCmd.TransferDatabase A_EXPORT, "ODBC Database", <db>,

Before using Access 2002, we were using Access 97 and
with that old version, the varchar fields were create as
such on SQL Anywhere. With Access 2002, it is not the
case anymore - they have the char datatype.

I know that with this 'TransferDatabase' process, we have
to add index, not null properties, etc... on the SQL
Anywhere database (we have a post script that is doing
that). So I want to avoid doing in that post script
hundreds of ALTER TABLE <table_name> MODIFY <field_name>
varchar(<length>)... because on a big database it takes
HOURS.

So the question is simple.
Am I missing something that could force Access to
generate 'varchar' when needed instead of char ?
If no, how can we do it at a low performance cost ?

Thanks
Till later
Muravenn