Results 1 to 3 of 3
  1. #1
    SteveDurham is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jul 2011
    Posts
    8

    2010 Runtime ADODB Connection Failure

    I have a routine which connects to MySQL database with ADODB connection. This worked in 2003 and 2007 runtime but throws a 430 error on 2010 runtime. It works in full access 2010. Has there been a change of policy to restrict this type of connection in the 2010 runtime?



    If I use a linked ODBC table instead of ADODB the runtime fails with "Runtime Error". It still works in full access.

  2. #2
    BruceComo is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2011
    Posts
    1

    adodb connection failuare

    Hi Steve,

    Did you ever find a solution to your problem? I'm having a very similar issue.

    For me, the run time (uninstalled sp1) chokes on the assignment of my global connection object: Set gcon = New ADODB.Connection

    Bruce

  3. #3
    boblarson is offline --------
    Windows 7 64bit Access 2010 32bit
    Join Date
    Jun 2011
    Posts
    1,272
    Quote Originally Posted by BruceComo View Post
    Hi Steve,

    Did you ever find a solution to your problem? I'm having a very similar issue.

    For me, the run time (uninstalled sp1) chokes on the assignment of my global connection object: Set gcon = New ADODB.Connection

    Bruce
    Have you gone to the VBA window and done a COMPILE since uninstalling SP1? ADO keys changed in SP1 so reverting would cause a problem if it hasn't been recompiled. You may need to run a decompile first though.

    But the question also is do you have Windows 7 SP1 installed? SP1 of Windows 7 also caused a problem with ADO registry keys.

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

Similar Threads

  1. Replies: 7
    Last Post: 02-19-2012, 04:40 PM
  2. Hide Access 2010 runtime window
    By cevatyildiz in forum Programming
    Replies: 4
    Last Post: 03-28-2011, 07:28 AM
  3. access runtime for 2010
    By wthoffman in forum Access
    Replies: 1
    Last Post: 01-28-2011, 07:28 PM
  4. Date Range Failure
    By goodguy in forum Queries
    Replies: 4
    Last Post: 12-30-2010, 10:22 AM
  5. Duplicate record failure
    By bugchaser in forum Access
    Replies: 5
    Last Post: 05-21-2009, 08:38 AM

Tags for this Thread

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