Hi all

I a have a linked table in my access database that links to a sql server table. Every month the sql server table gets dropped and recreated with different column names. When you then try to open the link table in access it errors as the column names have changed. What I wanted to do was some how in vb6 drop the linked table and re-create it as a linked table ?? any ideas how I would go about this ?

Thanks for the help