Hello,
It seems that there is some latency with MS Query? I add a value into our SQL Server database, but my sheet that uses MS Query doesn't return the value right away, but I know it's in the database because I see it in the table. Then after awhile, I can query and display the new data in an MS Query in my sheet. Strange.
Also, I've gotten this alert:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'TEST' cannot be opened. It is in the middle of a restore.
Thanks,
Jean Luc
It seems that there is some latency with MS Query? I add a value into our SQL Server database, but my sheet that uses MS Query doesn't return the value right away, but I know it's in the database because I see it in the table. Then after awhile, I can query and display the new data in an MS Query in my sheet. Strange.
Also, I've gotten this alert:
[Microsoft][ODBC SQL Server Driver][SQL Server]Database 'TEST' cannot be opened. It is in the middle of a restore.
Thanks,
Jean Luc