I searched everywhere and found out there isn't an option to do this. Took me a little while but here is the workaround if anyone is interested.
'Application.Echo False - is optional (turns off screen refresh)
Application.Echo False
'Selects the Database Window
DoCmd.SelectObject acTable...
Is there a way to programmatically refresh the table list in a Access 2000 Project? I'm creating a table inside a SQL Stored Proc and using the DoCmd.TransferSpreadsheet to transfer the table's contents to a excel file.
I noticed that if the table does not exist before the Project is initially...
What version of MDAC are you using? I've run into numerous problems with Recordsets before I updated my MDAC from microsoft http://www.microsoft.com/data/. It might correct your problem or at least you will know it isn't a ADO problem.
Is there a way to programmatically refresh the table list in a Access 2000 Project? I'm creating a table inside a SQL Stored Proc and using the DoCmd.TransferSpreadsheet to transfer the table's contents to a excel file.
I did notice that if the table does not exist before the Project is...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.