Changing Data Type

[Valentine]

I am trying to change a data type from "Short Text" to "Long Text" because i want to put in something that is more than 255 characters. I am getting an error "Operation is not supported for this type of object" I am confused.....

 

[theDBguy]

Are we talking about SQL Server?

 

[Valentine]

Just a table in access, it is linked to sharepoint...I am going to see if i can change it in sharepoint. I treid changing it on a local unlinked table and it worked I think my error is sharepoint.

 

[theDBguy]

Just a table in access, it is linked to sharepoint...I am going to see if i can change it in sharepoint. I treid changing it on a local unlinked table and it worked I think my error is sharepoint.

When dealing with linked data source, any changes to its structure will have to be done at the source.

 

[oleronesoftwares]

Just to add to what theDBguy wrote, linked table only allow you to view data structures, you will have to go to the data source of the linked table to change any data type etc, then refresh the linked table in the application you are calling it from.

 

[onur_can]

Hello, you need to change the data type on the local table.