
Adding new column to existing table
On Sun, 20 Jan 2002 23:05:07 +1100, "Paul"
Quote:
>Thanks for the tips, but does ADOX work with VB6? Thought that's with .NET.
Of course it does! The full release version of .Net was just released
this week. ADOX has existed since ADO 2.1 (IIRC - I may be off by a
version or two). Here's my FAQ response to ADOX questions:
This article:
<http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnda...>
gives you a good overview. Just don't duplicate the author's use of
Dim var As New Something.
Instead, when you use her sample code, change it to
Dim var As Something
Set var = New Something
The former syntax, while it works, has fallen out of favor with
experienced programmers who wish to retain control over when objects
are created and destroyed.
Here are some other useful links (Thanks to Doug Steele):
Well, unless you're doing it as a learning exercise, I wouldn't bother
[switching to ADO].
Access is actually much better off using DAO than ADO. It's faster,
and
there are lots of things you can do in DAO that you can't in ADO (see
Michka's [Michael Kaplan] article "INFO: What does DAO have that
ADO/ADOx/JRO do not have
(and might never have!) at
http://www.trigeminal.com/usenet/usenet025.asp )
If you're determined, though, you might find the following articles
useful:
Porting DAO Code to ADO with the Microsoft Jet Provider
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnda...
daotoado.asp?frame=true
INFO: Issues Migrating from DAO/Jet to ADO/Jet
http://support.microsoft.com/support/kb/articles/Q225/0/48.ASP
The ADO Rosetta Stone
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnad...
msdn_adorosest.asp
HTH,
Bob Barrows
Please reply to the newsgroup. My reply-to address is my "spam trap" and I don't check it very often.