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

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?

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

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.