Hi,
I have many buttons in Access ADP that trigger feeding a table with different data.
Let's call the table tempTable1. I have 600 buttons that feed the make table with all kinds of data:
There is another menu bar button that only opens
tempTable1. The result for tempTable1 is always correct when you use Query Analyzer. However Access ADP recognizes the change in the table structure when the connection is refreshed. Is there is any way that we can automate the connection refresh procedure or an easier way to get the desired results?
Am using Access 2003 connected to SQL 2005 and trigering the events via VBA.
thank you,
Alibaba
Let's call the table tempTable1. I have 600 buttons that feed the make table with all kinds of data:
Code:
SELECT * INTO tempTable1 From AnyDataSourceSPViewTable
SELECT FIELD1, FIELD7 into temptable1 from AnyView ...There is another menu bar button that only opens
tempTable1. The result for tempTable1 is always correct when you use Query Analyzer. However Access ADP recognizes the change in the table structure when the connection is refreshed. Is there is any way that we can automate the connection refresh procedure or an easier way to get the desired results?
Am using Access 2003 connected to SQL 2005 and trigering the events via VBA.
thank you,
Alibaba
