Click here to Skip to main content
11,481,404 members (66,371 online)
Rate this: bad
good
Please Sign up or sign in to vote.
See more: VB6
How to add columns to Ms Access database using Vb6
Posted 16-Jun-11 4:49am
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 1

Try this[^]
  Permalink  
Rate this: bad
good
Please Sign up or sign in to vote.

Solution 2

these are sample queries for adding column in access database using vb6
alter table UrTableName add ColumName varchar(size) null

alter table UrTableName add ColumName Memo null

alter table UrTableName add ColumName bit null

alter table UrTableName add ColumName DateTime Not null

alter table UrTableName add ColumName single null

alter table UrTableName add ColumName double null

alter table UrTableName add ColumName varchar(size) null

alter table UrTableName add ColumName byte null

alter table UrTableName add ColumName int null

use connection object and execute query for add column in access.
example
cn.Execute (InsertStrQry)
  Permalink  

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 4 Jun 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100