Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
|
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 15th, 2004, 07:32 AM
Registered User
 
Join Date: Apr 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default Connection issues with ADP file

I have an Access Data Project that is returning the following error msg for one user only: 'run-time error 430' "Class does not
support automation or does not support expected
interface. "
  When I press debug, it takes me to the following line of
code:
"set conn = currentproject.connection"

  It looks like some sort of issue with
currentproject.connection, but I'm not sure what it could
be. Again, Only one user is having this problem. They
can open the forms without a problem, but none of the
combo boxes are populated.

 
Old June 15th, 2004, 03:54 PM
Friend of Wrox
 
Join Date: Nov 2003
Posts: 625
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to jemacc
Default

The user may have a different version of MDAC than the rest.

This error may occur when software attempts to access a database file by referencing libraries that are a different version than those installed on the computer. Update the MDAC to version consisting with your application and make sure all references to the DLL are registered.

 
Old June 17th, 2004, 08:02 PM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I do not think that you can use currentproject.connection in an ADP. Use an ADO connection instead.



Sal
 
Old June 18th, 2004, 03:10 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Just as a point of clarification, CurrentProject.Connection is fine in ADPs too. For example, the following dumps the contents of the Customers table to the debug window in both the Northwind and the NorthwindCS DBs.

Sub Main()
    Dim cnn As ADODB.Connection
    Dim rst As ADODB.Recordset
    Dim strSQL As String

    Set cnn = CurrentProject.Connection

    strSQL = "SELECT * FROM Customers"

    Set rst = New ADODB.Recordset
    rst.Open strSQL, cnn

   ' Print the values for the fields in
   ' the recordset in the debug window
    Debug.Print rst.GetString(adClipString, , ";")

End Sub


Bob

 
Old June 18th, 2004, 04:26 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 120
Thanks: 0
Thanked 0 Times in 0 Posts
Default

There's no problem with using currentproject.connection in an ADP.


Brian Skelton
Braxis Computer Services Ltd.
 
Old June 18th, 2004, 09:11 AM
Registered User
 
Join Date: Apr 2004
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thanks for all the help. I think the MDAC issus is probably the most likely. Unfortunately, I haven't been able to get the user to update yet, so I don't know for sure. I did find the MS Knowledge Base article below.

http://support.microsoft.com/default...;en-us;Q248404



 
Old June 19th, 2004, 10:56 AM
sal sal is offline
Friend of Wrox
 
Join Date: Oct 2003
Posts: 702
Thanks: 0
Thanked 0 Times in 0 Posts
Default

I stand corrected. Thank you Bob. By the way, welcome back to the forum.



Sal
 
Old June 19th, 2004, 01:54 PM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Thanks Sal. Glad to see the Access/Access VBA forums are still alive and well. I've been off in .NET land, but just installed Access 2003 and figured it would be a good time to try and remember all the Access stuff I forgot.

Bob






Similar Threads
Thread Thread Starter Forum Replies Last Post
connection string issues, web.config file issues kaliaparijat ASP.NET 2.0 Professional 1 June 12th, 2008 08:07 AM
SQL Connection/Database Issues fs22 ASP.NET 2.0 Basics 0 August 1st, 2006 03:17 PM
Connection State in ADP Scripts82 Access VBA 3 April 6th, 2006 09:48 PM
Date issues with ADP file Wango Access 2 June 15th, 2004 04:22 AM
ADP connection error lhedquist Access 6 April 29th, 2004 09:14 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.