RE: Access Field Types

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

From: Peter Huang (v-phuang_at_online.microsoft.com)
Date: 05/07/04


Date: Fri, 07 May 2004 03:11:24 GMT

Hi,

I have reviewed the newsgroup and find that you have post a similar post in
the group below.

Subject: Changing Field Type On MS Access using ADO/VB
Newsgroups: microsoft.public.vb.database.ado

I think Gary's suggestion in the group above that to use the ADOX to do the
job is an approach.
Also because ADOX is an COM object we can use it in .NET easier by simply
adding reference to the ADOX library and the VS.NET will generate the
assembly which is used to interop with ADOX COM object automatically.
e.g.
1. right click on the reference in the solution explorer and select add
reference
2. in the Add reference dialog select the COM tab and select the Microsoft
ADO Ext. 2.7 for DDL and Security COM library and click OK

After that we can use the ADOX object in VB.NET similar with what will do
in VB6, you may follow the link that Gary provided.

If you still have any concern on this issue, please feel free to post here.

Best regards,

Peter Huang
Microsoft Online Partner Support

Get Secure! - www.microsoft.com/security
This posting is provided "AS IS" with no warranties, and confers no rights.



Relevant Pages

  • Re: Access Field Types
    ... Best Regards - OHM ... > Also because ADOX is an COM object we can use it in .NET easier by simply ... > adding reference to the ADOX library and the VS.NET will generate the ... > Microsoft Online Partner Support ...
    (microsoft.public.dotnet.languages.vb)
  • RE: time to demote a dc on a site
    ... By the way, just for your reference, the newsgroup can either be reached ... with a NNTP client or through the web. ... Microsoft Online Partner Support ...
    (microsoft.public.win2000.active_directory)
  • RE: Server 2000 to Server 2008 NO exchange
    ... we answer one issue per post in the newsgroup. ... more clear for others' reference. ... Microsoft Online Partner Support ...
    (microsoft.public.windows.server.migration)
  • RE: Scecli and jet database event 1005 and 1202 repeating
    ... keep it as a reference. ... Microsoft CSS Online Newsgroup Support ... Yes it is a SBS 2003 server, sorry for the mistake, thanks it totally ...
    (microsoft.public.windows.server.sbs)
  • Re: Windjammer Reportedly Cancels Nov. 3 "Restart" Cruise
    ... their Website is at http://www.star-clippers.com. ... websites as a reference can hardly be considered advertising. ... John Sisker, SHITO-SHORE CRUISE AGENCY® ... newsgroup then I suggest you can either: ...
    (rec.travel.cruises)