modify link table property

[inungh]

I have a text file link table and set up all the fields and data type
when I linked the table.

There is one field has value more than 32767,but I set to integer.

I tried to change the field type from integer to long integer, but MS
Access does not allow change the field type for link table. Is it
delete and re link and table and set up field only solution?

I beleive that I can re link to other text file and keep all fields
data type.

Your information is great appreciated,

 

[fredg]

I have a text file link table and set up all the fields and data type
when I linked the table.

There is one field has value more than 32767,but I set to integer.

I tried to change the field type from integer to long integer, but MS
Access does not allow change the field type for link table. Is it
delete and re link and table and set up field only solution?

I beleive that I can re link to other text file and keep all fields
data type.

Your information is great appreciated,

Open the database which contains the table that you are linked to.
Modify the table field's Field Size property from Integer to Long
Integer.
Save the change.
Now open your regular database. The change should be in effect.