PC Review


Reply
Thread Tools Rate Thread

ADOX Catalog view

 
 
deepdiver
Guest
Posts: n/a
 
      5th Oct 2009
I append a view with ADOX Catalog and View object to an access 2000
database, the object can be used but is completly hidden?
 
Reply With Quote
 
 
 
 
Douglas J. Steele
Guest
Posts: n/a
 
      5th Oct 2009
Are you talking about a view involved tables in a Jet database (i.e. an
MDB), or in some other RDMS? If it's Jet, you're far better off using DAO
than ADOX.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"deepdiver" <(E-Mail Removed)> wrote in message
news:9df21a24-54f2-4dbb-83f3-(E-Mail Removed)...
>I append a view with ADOX Catalog and View object to an access 2000
> database, the object can be used but is completly hidden?



 
Reply With Quote
 
deepdiver
Guest
Posts: n/a
 
      5th Oct 2009
On 5 Okt., 11:58, "Douglas J. Steele"
<NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> Are you talking about a view involved tables in a Jet database (i.e. an
> MDB), or in some other RDMS? If it's Jet, you're far better off using DAO
> than ADOX.
>
> --
> Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> (no e-mails, please!)
>
> "deepdiver" <werner.bro...@gmail.com> wrote in message
>
> news:9df21a24-54f2-4dbb-83f3-(E-Mail Removed)...
>
> >I append a view with ADOX Catalog and View object to an access 2000
> > database, the object can be used but is completly hidden?



Yes i am talking about views using tables in a jet database.

This more or less well known code works fine with the exception that
these created views are not visible, but can be used.

ADOX::Catalog ^cat = gcnew Catalog();
cat->Create(this->ConnStr);
ADODB::Command ^adocmd = gcnew ADODB::Command;
adocmd->CommandText = "SELECT settings.* FROM settings;";
cat->Views->Append("hugo",adocmd);

thx & kr/Werner Broser

 
Reply With Quote
 
deepdiver
Guest
Posts: n/a
 
      5th Oct 2009
On Oct 5, 12:41*pm, deepdiver <werner.bro...@gmail.com> wrote:
> On 5 Okt., 11:58, "Douglas J. Steele"
>
> <NOSPAM_djsteele@NOSPAM_gmail.com> wrote:
> > Are you talking about a view involved tables in a Jet database (i.e. an
> > MDB), or in some other RDMS? If it's Jet, you're far better off using DAO
> > than ADOX.

>
> > --
> > Doug Steele, Microsoft Access MVPhttp://I.Am/DougSteele
> > (no e-mails, please!)

>
> > "deepdiver" <werner.bro...@gmail.com> wrote in message

>
> >news:9df21a24-54f2-4dbb-83f3-(E-Mail Removed)....

>
> > >I append a view with ADOX Catalog and View object to an access 2000
> > > database, the object can be used but is completly hidden?

>
> Yes i am talking about views using tables in a jet database.
>
> This more or less well known code works fine with the exception that
> these created views are not visible, but can be used.
>
> * * * * * * * * ADOX::Catalog ^cat = gcnew Catalog();
> * * * * * * * * cat->Create(this->ConnStr);
> * * * * * * * * ADODB::Command ^adocmd = gcnew ADODB::Command;
> * * * * * * * * adocmd->CommandText = "SELECT settings.* FROM settings;";
> * * * * * * * * cat->Views->Append("hugo",adocmd);
>
> thx & kr/Werner Broser



i think i found it, it is per design
msdn says a view created with adox or create view statement (which
should be possible with jet 4, but is not)
does not appear in the interface.
 
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 =?Utf-8?B?RGlvbg==?= Microsoft Access VBA Modules 0 23rd Aug 2007 10:42 PM
ADOX.Catalog =?Utf-8?B?R3JlZ29yeSBQb3Vsbw==?= Microsoft Access 6 21st Jul 2005 11:26 AM
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
ADOX Catalog gr Microsoft Access VBA Modules 4 14th Apr 2004 04:24 PM
Help with ADOX.Catalog =?Utf-8?B?TURX?= Microsoft Access VBA Modules 2 7th Apr 2004 02:21 PM


Features
 

Advertising
 

Newsgroups
 


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