"Jozef" <NO****@NOSPAM.com> wrote in message
news:Ifane.1532585$6l.1449168@pd7tw2no...
Hello,
I'm hoping enough time has passed now that someone could tell me what
methods have replaced the Database / Workspace / TableDef collections in
Access XP. I've tried asking this question before, quite some time ago,
but have been told "Just throw in a reference to DAO and away you go".
That's not the answer I'm looking for.
I'd like to know how to reference a database or a tabledef "the new way",
but I can't seem to find out what "the new way" is because the Access help
file also contains all the old items as well. Any help or even a keyword
would be appreciated.
Thanks!
Jo
.... database or tabledef? You may find that to do what you want to do, you
may need to use more than one object library. If you needed a recordset
then you might use the ADODB.Recordset object, but for working with tables
you would use the ADOX.Table object. You could set a reference to these
libraries and explore their object models and (if it ever works) the help
file. Failing that, there is online help - for example if you want to write
new code without using the tabledef object, you could look here:
http://msdn.microsoft.com/library/de...ce10052000.asp
You should be aware that not everyone would agree that the DAO object model
has been replaced - there are still things which cannot be done with these
new libraries and even these have been replaced by objects under the .net
framework. Although these are not available for Access, many asp.net vb.net
applications are using the new object models. In short, there needs to be a
pretty convincing reason to replace DAO.TableDef objects with ADOX.Table
objects.