Yep it was working before, and it works if I drop that column so that everything is in its original state. Strange one.

Thanks for the help this far, Ill keep trying!

Tried deleting and relinking to no avail. Anything I can try server side?

Thanks for all the help Jeff.

Having now successfully added the field I am having trouble actually adding any data to it from the access front end. I get messages similiar to...

sorry if I am in the wrong place (if so can it be moved)

just an update - I think I have figured out how to add a new column using...

er....it must be 2k then?

Hi Thanks

I am still stuck i'm afraid.  Heres what I tried:

I opened my database

Right-clicked on stored procedures and chose new stored procedure.

In the pop-up window I replaced the text that...

Thanks. Are they stored procedures? How do you use those?

sorry really am a complete beginner