Frosty the Coder
Legendary Poster
I got handed a World acct that has an access table linked to a 400 table.
I don't know a thing about access.
Anyway, the key on both tables, is WNUM, which is 10 characters.
They need this to be 20 characters.
When in access, they are getting a "can't save properties on linked table" or similar message.
Where do the tables get linked?
How do we break/re-establish that link?
When the link IS down, we plan on changing the access WNUM to 20 characters.
On the 400, we are replacing WNUM w/ DRAW which is 20 characters.
Will access be able to link WNUM to DRAW, or do we have to
change access to use DRAW as well?
TIA
Gene
I don't know a thing about access.
Anyway, the key on both tables, is WNUM, which is 10 characters.
They need this to be 20 characters.
When in access, they are getting a "can't save properties on linked table" or similar message.
Where do the tables get linked?
How do we break/re-establish that link?
When the link IS down, we plan on changing the access WNUM to 20 characters.
On the 400, we are replacing WNUM w/ DRAW which is 20 characters.
Will access be able to link WNUM to DRAW, or do we have to
change access to use DRAW as well?
TIA
Gene