PC Review


Reply
Thread Tools Rate Thread

ADOX Append View Problem

 
 
Kev
Guest
Posts: n/a
 
      13th Jan 2004
Can anyone help me with this:
I am trying to create a view via ADOX with the following
code:

Dim cnnMfd As New ADODB.Connection
Dim catMfd As New ADOX.Catalog
Dim cmdMfd As New ADODB.Command

cnnMfd.Open CurrentProject.AccessConnection
Set catMfd.ActiveConnection = cnnMfd
cmdMfd.CommandText = strSQL
catMfd.Views.Append "qryDataDump", cmdMfd

I have set references to both the ActiveX Data Objects
2.7 Library and the ADO Ext. 2.7 for DDL and Security
Library.

My problem is when I run it I get a Runtime Error (-
2147467262(80004002)) stating "No such Interface
Supported" when running the last line of code.

Any ideas?

Thanks in Advance,

Kev

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
ADOX Catalog view deepdiver Microsoft Access 3 5th Oct 2009 02:49 PM
ADOX Problem Mr. B Microsoft ADO .NET 2 5th Dec 2005 06:29 PM
ADOX performance problem: first attempt to read value from open ADOX catalog lasts long time lampi Microsoft Access 0 28th Apr 2005 01:21 PM
RE: Append problem in Datasheet View. =?Utf-8?B?U0NITllERVM=?= Microsoft Access 0 11th May 2004 09:11 PM
ADOX Delete View Problem =?Utf-8?B?Qm9iIEV3ZXJz?= Microsoft Access VBA Modules 1 30th Jan 2004 05:31 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:07 AM.