Hi,
I have an Access 2003 Data Project in which programatically I import a load of data and then run an update query. I am having a problem though. I have a load of XML files which I import running in a loop, all importing with the same table name, for each import, I run and insert query to put the data into other tables, delete the table and move onto the next XML file. The problem is that the table is not always (but most of the time) getting deleted so I get tblData1, tblData2 etc etc.
I am guessing this is just a table refreshing issue, but how can I force a refresh of the tables so the front end knows it exists. Any other suggestions on why this would be happening much appreciated.
Cheers
Stu
I have an Access 2003 Data Project in which programatically I import a load of data and then run an update query. I am having a problem though. I have a load of XML files which I import running in a loop, all importing with the same table name, for each import, I run and insert query to put the data into other tables, delete the table and move onto the next XML file. The problem is that the table is not always (but most of the time) getting deleted so I get tblData1, tblData2 etc etc.
I am guessing this is just a table refreshing issue, but how can I force a refresh of the tables so the front end knows it exists. Any other suggestions on why this would be happening much appreciated.
Cheers
Stu
