Increasing field size with linked tables

[rtucker]

I'd like to increase a field size to allow input of 16 characters versus the
current 11, but I have a message that says I can't do it because of linked
tables. I'm guessing I can't do it at my work station. I need to do it at
the server. However, I only have a small working knowledge of access/sql
server. Any help would be appreciated. I hate to pay $100+ an hour for the
tech guys to come back out again for something that should be simple.

Thanks

 

[Jeff Boyce]

Do you have a way to open the .mdb file on the server? If so, make the
change to the table in the back-end there. If you don't have access to it,
call tech!

Good luck

Jeff Boyce
<Access MVP>

 

[Jeff Boyce]

P.S. BACKUP, BACKUP, BACKUP!

Jeff

 

[rtucker913]

I have gone in on the server and using a SQL program to manage/edit the
database found the table "students" I was looking for and then the field and
changed the number from 11 to 16. However, when I come back to my
workstation and try to enter more than 16 characters in the field, I get the
same old message. The table students when viewed from the workstation shows
11 in the field size versus the 16 set for field size at the server. Also,
the field is set up to take data as such: &&&CCCCCCCCCCCCC;0;" "

Thanks Jeff.

 

[Jeff Boyce]

Your "front-end" may need to be told that the back-end has been changed.
From within the front-end, from the database window, use Tools | Database
Utilities | Linked Table Manager (exact path may vary, depending on the
version you are using).

Select this table and refresh the link.

Good luck

Jeff Boyce
<Access MVP>

 

[rtucker913]

Thanks so much Jeff. That worked. If you need an environmental question
answered, I'd be happy to repay you.

 

[Jeff Boyce]

You don't need to repay me ... but you are welcome to help someone else
along...

Jeff