Programatically creating a new field in a linked table

[Radu84]

I wrote some code that programatically creates a new field in a table that is linked to a backend db.

I accomplished this by creating a copy of the backend db, running an Alter Table query, and then overwriting the original backend db.
After this I run a refreshlink command for the modified table. Everything seems to work ok, just that ( in the same function) when I execute a Insert Into query, it doesnt see the new field. (Error 3127 unknown field).

If I manually run a query afterwards , it works fine.

Any tips on what the problem could be are welcome

 

[Oldsoftboss]

This is how I update a back end

http://www.access-programmers.co.uk/forums/showthread.php?t=97434

HTH

Dave

 

[Radu84]

I get it to work fine, except for the fact that it won't recognize the newly created field immediately (in the scope of the same function). If I go afterwards and run a query on the new fields it works ok. What could be causing this 'delay' ?

 

[Radu84]

Any help pls ?