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 initially opened, and the table is newly created, that it gives me an error 7874 when I try to export the table via the DoCmd.TransferSpreadsheet function.
The table does exist on the SQL side, but, when I cycled through the tables catalog in the Access Project it didn't exist. Finally, I selected the tables list and pressed F5 (refresh) and the table appeared.
I did notice that if the table does not exist before the Project is initially opened, and the table is newly created, that it gives me an error 7874 when I try to export the table via the DoCmd.TransferSpreadsheet function.
The table does exist on the SQL side, but, when I cycled through the tables catalog in the Access Project it didn't exist. Finally, I selected the tables list and pressed F5 (refresh) and the table appeared.