Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Oct 2011
    Posts
    3
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Connecting Access 2003 to SQL Server

    I've had an Access 2003 ADE connecting to SQL Server for quite some time, but it recently stopped working. I get this message: "430 - Class does not support Automation or does not support expected interface."

    After much trial and error I have determined the statement is issued when I try to execute
    set conn = CurrentDB.Connection

    where conn is defined as
    dim conn as new ADODB.Connection

    This has worked for years, and now I get this message. What I do know is that the result varies with the Windows environment. The program works fine on Windows 7 boxes, but I get that error message on both Windows XP boxes and a Windows Server 8 box used for Citrix. Apparently the problem is not the program code but the environment, somehow. What can you suggest as to why it does this, or how to fix it? I appreciate any suggestions you can make, short of switching everything to Windows 7. I've already thought of that, and it won't fly upstairs.

    Dale Napier

  2. #2
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,624
    Thanks
    3
    Thanked 60 Times in 60 Posts
    Is it possible that you have a reference to ADO that can't be resolved on the systems giving an error? If your development environment has moved to Win7, and that's where you compile the ADE, the older systems may not be able to resolve the reference. Try putting an ADP on one of the boxes that fail and see if you get a missing reference in VBA.
    Wendell

  3. #3
    5 Star Lounger AndrewKKWalker's Avatar
    Join Date
    Apr 2001
    Location
    Cambridge, UK
    Posts
    1,020
    Thanks
    0
    Thanked 3 Times in 3 Posts
    I am a bit late to this thread.....

    But you could try the line below, although it sounds like a library issue.

    set conn = CurrentProject.Connection

    There is a bug on Windows 7 with SP1 and the connection object.
    When the project is compiled as far as I know, the connection object gets compiled to a different data type.
    So if then run on XP it fails. I have had this issue turning up ever since Windows 7 SP1.
    However, the message with this issue is normally a Mismatch error, so it may not be related to your situation.
    Andrew

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
  •