Can't copy into field after disable lookup feature

[plasticman]

Hi guys,



I'm very new to MS Access so maybe I mess up some term, but I'll try my best to explain what the problem is.

I have a DB with several tables in it. Some of fields in this tables are connected with other fields and they suppose to be filled with values from connected field. It's a lookup fields.
I need to copy data to these lookup fields from an excel file.
So I delete this connections at DB designer. Then at table designer I change field type from Lookup Field to Field at Lookup tab. And when I try to save these changes I get message saying that afeter saving this lookup field will be read only. And I really can't write anything in them.
Is there a way to put data to these lookup fields after I make them normal?

[RuralGuy]

Is this how you changed your Lookup Fields?
http://www.btabdevelopment.com/main/...1/Default.aspx

[plasticman]

yes exactly

[RuralGuy]

I'm not familiar with the message you are getting. If all you did was change the lookup from a ComboBox to a TextBox then I'm surprised you are getting this message. Is this an internal table or a linked table?

[plasticman]

I suppose it's linked. I'm opening ms sharepoint list with ms access. If I make any changes in these tables sharepoint list will change too.

[RuralGuy]

I've not used SharePoint. Maybe the message is coming out of that product. I know nothing about SharePoint, sorry.