Changes in my Access DB wont reflect in project

[johncassell]

Hi there,

I have an Access DB which has a table in it and one of the fields used to accept only numbers.

I changed this so it accepts any text but my Visual Studio project does not recognise the change and I wondered if there was an easy way to make it reflect.

Does anyone know how I can do this?

Thanks

John

 

[ashishnaicker]

Have you tried re-configuring the table adapters?

 

[johncassell]

How do I do that please?

I have tried right clicking and 'refresh' but that makes no difference.

Thanks for the reply as well.

John

 

[johncassell]

Doesn't matter, I got it now.

Right click data source, configure dataset with wizard, then look for new tables etc.. and select them all as needed.

Thanks

John

 

[cjard]

How do I do that please?

I have tried right clicking and 'refresh' but that makes no difference.

Thanks for the reply as well.

John

Refresh wont work (it isnt for that purpose).. You right click the tableadapter of the table you have changed, and choose CONFIGURE. The wizard appears to take you through this table.. just leave everything as is, and click next next next..
You may also see a message saying "Do you want to alter the Updating commands to reflect the change?"
Yes you do