Re: How to retrive data from an external database?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Alp (me_at_my.com)
Date: 09/22/04 

Date: Wed, 22 Sep 2004 16:21:50 +0800

Hi Tim,

Thanks for you reply. Most probably its me (or the ref's) but I can't seem
to get anywhere. I would like to actually see the result of this query. I
did try quite a few stuff but still couldn't manage to get it displayed.
Once I am done with that, then I'll try and input that to a table.
Any further suggestions?

Alp
P.S.: If run within the db in question this does what I need (in basics that
is):
SELECT MSysObjects.Name, MSysObjects.DateCreate, MSysObjects.DateUpdate,
MSysObjects.Type, MSysObjects.Flags
FROM MSysObjects;

"Tim Ferguson" <FergusonTG@softhome.net> wrote in message
news:Xns956BB04012D6Bgarbleme4455656@207.46.248.16...
> "Alp" <me@my.com> wrote in news:#zdzlV9nEHA.3868@TK2MSFTNGP11.phx.gbl:
>
> > I would like to query an mdb's/mde's MSysObjects from another
> > database. Sole purpose of this is to get the object names, creation &
> > update dates and what they are (types).
> >
>
> set db = ws.OpenDatabase(strPath, true, true)
> Set rs = db.OpenRecordset( _
> "SELECT Something, SomethingElse " & vbcrlf & _
> "FROM MSysObject" & vbCrLf & _
> "WHERE ObjectType = 409" & vbCrLf & _
> "ORDER BY SomethingElse", _
> dbOpenSnapshot, dbForwardOnly
>
> With rs
> .DoSomethingUseful
>
> End With
>
>
> I strongly suspect you will run into permission problems, but you can
> always have a go. There probably is something in the square-bracket
> syntax you could use:
>
> SELECT Something, SomethingElse
> FROM MySysObjects IN [Database=f:\someonesdata\someonesdb.mdb]
> WHERE etc, etc
>
> but I don't use that very often. Bear in mind that the structure of the
> system tables is not documented and not guaranteed to remain the same in
> subsequent versions of Access.
>
> HTH
>
>
> Tim F
>

Relevant Pages

  • Re: sweet-expressions instead of s-expressions?
    ... aren't excellent but somewhat tangential to what I had in mind. ... words: "Remember in thinking through this: Don't fight the syntax! ... reader macros) is either necessary nor particularly appropriate in the ... Lisp, and I don't think that he ...
    (comp.lang.lisp)
  • Re: increasing the RPS of any page
    ... - performance test as you develop, getting ridding of slow or cpu ... - remember that response.write(your html) is probably much more ... also bear in mind the big difference between slow through waiting (low ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: Technical issue with this site
    ... you're confused (or ignorant) of what you're posting to in the first ... You have to bear in mind that my first exposure to computers ... That hair would, for Tina, be a six-inch steel hawser. ...
    (rec.arts.sf.composition)
  • The Biggest Experiments in Science
    ... The ITER nuclear fusion project ... Laser Interferometer Wave Observatory ... Also bear in mind that I work in TV and too many equations tend to ...
    (sci.physics.research)
  • Re: BBC on Emley moor.
    ... >>> Also bear in mind that not all frequencies protend the same ... the last person to call me William was a Sunday School teacher who ... But just bear in mind that if you call me William I will visualise ...
    (uk.tech.digital-tv)