I am developing on SQL Azure with Access 2010 as a front end. I set up te linked tables, pass-through queries correctly and everything seemed to be fine.
A while later, though, I am starting to get "Call to ODBC Failed" errors (mostly timeout) on Occasion. Especially concerning large imports of data from Access to SQL Azure (which was tested and working in the original version). I have to restart the application in order to begin using the database again (not ideal for a real-life scenario).
I can set the Timeout to 0 on the database, I suppose, but that might not be best practice. Tried this with the second big query, but I just eventually got another error (was in a hurry out door, should have gotten a screen shot or something--sorry).
Does anyone have any experience with this, or perhaps have some relatable knowledge with SQL Server and Access in general?