Adding (Access) fields via VB6

[draugen]

I have an access file that is called Vedlikeholds_Rutiner.mdb. The path of the access file is:
c:\IKDV\Vedlikeholds_Rutiner.mdb.
I need a new field(collumn) called katagori to be added to Vedlikeholds_Rutiner.mdb.
Is there a way to add it via a VB6 program? If so how?
Thanks ahead of time.

 

[HarleyQuinn]

You can do this quite easily using DAO, here's a short example. There's also an ADO example within this FAQ on TT itself (faq222-1422).

Hope this helps

HarleyQuinn
---------------------------------
Carter, hand me my thinking grenades!

You can hang outside in the sun all day tossing a ball around, or you can sit at your computer and do something that matters. - Eric Cartman

Get the most out of Tek-Tips, read FAQ222-2244: How to get the best answers before posting.

http://lessthandot.com