Re: SourceTableName truncate

"Anthony England" <aengland@xxxxxxxxxx> wrote in
news:dtc4k8$mdb$1@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx:

This is always a possibilty but in general you are advised against
using MSysObjects directly. While the DAO and ADO object
libraries are provided for programmers to use, MSysObjects is not.
You have no guarantee that code which currently works will
continue to work - changes may be made to this system table which
are beyond your control. Having said that, I think you would be
fairly safe with this one, especially if you put in appropriate
error handling. However, I'm not sure what advantage you hope to
gain over the first function I proposed.

MichKa actually disagrees with this position somewhat in regard to
Jet:

http://trigeminal.com/usenet/usenet017.asp?1033

He describes Microsoft's policy on how these things work, that
nothing that any feature in any past version of Access depends on
will ever be changed, and outlines the kinds of things in system
tables that you can depend on.

By MichKa's formulation, this is one case where you'd be fine
relying on looking in MSysObjects directly, as by MS policy,
anything that's been implemented there is not going to be altered in
future versions of Access.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
.

Relevant Pages

  • Re: Costco has a great price for Gaggia Babby D - $169 less than WLL
    ... but it's not an external adjustment. ... Costco's return policy you'll recall that almost all of the goods they ... sell is backed by their 100% satisfaction guarantee. ... take it back to any Costco for you're money back. ...
    (alt.coffee)
  • Re: "Knowledge Management Policy"
    ... I add that books organize information. ... books, and then the libraries. ... > are constituted under some undefined organized naming system. ... > to have a KM policy at the corporate level, or at least I have been unable ...
    (microsoft.public.windowsxp.basics)
  • Re: Local Group Policy logoff script
    ... > have some Group Policy running on them, then you should be able to make a ... > The big problem I am having, is that I can't guarantee that the group ... > logon/logoff has been initialized on the machines that I will be running ... > script that I'm creating will not only setup my logon/logoff script ...
    (microsoft.public.win2000.group_policy)
  • Re: SourceTableName truncate
    ... While the DAO and ADO object ... libraries are provided for programmers to use, ... relying on looking in MSysObjects directly, as by MS policy, ... documented object libraries to write my code and I don't understand what ...
    (comp.databases.ms-access)
  • Re: 32 or 64 bit processor info in C
    ... never have I seen an 8-bit int. ... out that some programmers are untrustworthy, ... environment where the data type sizes change. ... I am arguing for keeping the existing policy that assigns ...
    (comp.lang.c)