How do I change Access table properties in a linked database. 1

[Evil8]

We have a rather large access 2003 database. Recently we've been having an issue with a field on multiple forms. The error is: The field is too small to accept the amount of data you attempted to add. I've looked at the underlaying tables and in two tables the record identifier "CLSiteCode" is set at a length of 50. In two other tables it is set at a length of 26. Now the tables are linked and cannot be modified, so I went to the Relationships view and it won't let me remove the links because you can't delete a relationship inherited from a linked database.

How do I fix this? I did not create this behemoth either, I just inherited it.

Thank you for any help!
Evil8

 

[SkipVought]

hi,

You really ought to post in one of the many MS Access forums like forum700.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[Evil8]

Thanks Skip!