Originally Posted by
osupratt
i separated this into two processes and command button operations. the first button places the datetime stamp on back-end table through SQL UPDATE and that works fine. the second button executes a SQL VIEW that outputs data and then the MS Access export wizard send a text file to specified location. The sending of the text file works fine. Problem is that it is now blank. Again, in one of my companies this process has worked for over 7 years without a glitch. So i go to SQL Server Management Studio after clicking first command button. I verify the datetime stamp placed correctly. I then try to execute the View in SSMS and no records pull up. I try this several times until after maybe 10 seconds when after executing the records show. So basically when in MS Access front-end clicking the button a second time after going out to a shared drive and verifying text file was blank then going back and clicking on it again was basically executing the View after so many seconds and re-running the export wizard. So this would obviously point to something on the server has changed or something in the View (which i know nothing has been changed there) is affecting the ability for the View to see the datetime stamps on the current set of records and pull them.