I appreciate Microsoft's position on undocumented features. They may
be removed or changed at any time. But I am a bit sceptical.
Are undocumented features so different from documented features? Do we
see, here in CDMA, almost every day, posts that describe upgrade woes,
outlining features that worked in a previous version but bring grief
in a newer version? I think we do. How many of these features are
undocumented? My recollection is, "None."
Can we name undocumented features that were present in Access 2000
which do not exist in Access 2007, or behave in a substantially
different way? I cannot. For instance, I have used the undocumented
property or function .Collect(Field-Index) which returns the value of
a record-set field more quickly than the "!" syntax or a .Value call
or a default property reference, thousands of times; to the best of my
knowledge this very useful feature works as expected in every version
of Access (more correctly I suppose in DAO and ADO). .Goto in place
of .SetFocus is another undocumented feature that can be found in my
code many times. It still works flawlessly. I can't remember why I
started to use this, but I think it was because it "Went-To" in some
circumstance where .SetFocus balked.
As for change we have only to look at the new Ribbon to decide, each
for himself or herself, if Microsoft has any commitment to making
change painless.
Does Microsoft encourage us to use Look-Up tables? Recordsets (when
SQL is an east alternative)? Yes?
Have a look at the SQL in Northwoods 2007! Is the inclusion of this in
Northwoods, encouragement?
Is what Microsoft encourages pertinent?
BTW, I am trying to write this in Google's new beta Chrome Browser.
It's very fast. It's spell checker may not be as helpful as some,
Safari's and Opera with GNU ASpell. It seems to take several seconds
to assess spelling and often there is no suggested alternative or a
very brief list.
On Sep 4, 1:08*am, Tom van Stiphout <no.spam.tom7...@cox.netwrote:
On Wed, 3 Sep 2008 15:03:26 -0700 (PDT), lyle fairfield
<lyle.fairfi...@gmail.comwrote:
But be aware that the MSys* tables are officially undocumented and
users are encouraged to use documented features.
-Tom.
Microsoft Access MVP
MsgBox CurrentProject.Connection.Execute("SELECT TOP 1 [DataBase] FROM
MSysOBjects WHERE Type = 6")(0)
On Sep 3, 8:18*am, "susan" <v...@hotmail.comwrote:
My application contains 2 databases:
appl.mdb and data.mdb. From appl.mdb I link to data.mdb.
How can I (in appl.mdb using a commandclick) display the full pathnameof
the data.mdb?