Results 1 to 3 of 3
  1. #1
    drexasaurus's Avatar
    drexasaurus is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Jul 2011
    Location
    Santa Ana, CA
    Posts
    60

    Access 2010 and SQL Azure

    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?

  2. #2
    TheShabz is offline Court Jester
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    1,368
    The only time I've seen Access function on the web is when paired with SharePoint. I've become a broken record in this forum on my stance with Access and the web but I honestly don't like it at all. php/MySQL. I have never heard the phrase "wow this works great" when it comes to an Access web interface. I know this isn't the kind of answer you're looking for. It's more of a heads-up to what you already have, and what you will continue to, run into.

  3. #3
    Aurelius7 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Mar 2012
    Posts
    4
    See my posts in the thread Access 2010 to SQL Azure migration in this forum. ODBC errors seem to just be a fact of life with Access, especially when paired with Azure which is picky about the way it retains and handles its connections. There are different ways to deal with some of these errors but not all of them are pretty. For instance, writing VBA to programmatically force a form to jump to the last record in its recordset then jump back to the first record (during the Form_Open event) and other such kludgey workarounds.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Change Access 2003 mdb workgroup using Access 2010
    By metsmaniac in forum Security
    Replies: 6
    Last Post: 04-06-2012, 08:56 PM
  2. Replies: 9
    Last Post: 08-07-2011, 11:21 AM
  3. Replies: 17
    Last Post: 08-03-2011, 05:19 PM
  4. Saving Access 2010 database to Access 2007
    By Bajaz001 in forum Access
    Replies: 2
    Last Post: 04-11-2011, 12:59 PM
  5. Opening Access 2000 file in Access 2010
    By Jacob in forum Access
    Replies: 10
    Last Post: 02-12-2011, 06:56 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums