Click here to Skip to main content
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 3: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)

  Print Answers RSS
0 OriginalGriff 255
1 Maciej Los 225
2 Manfred R. Bihy 190
3 CHill60 180
4 _Amy 155
0 OriginalGriff 7,395
1 Sergey Alexandrovich Kryukov 6,163
2 Maciej Los 3,754
3 Peter Leow 3,448
4 CHill60 2,702


Advertise | Privacy | Mobile
Web02 | 2.8.140721.1 | Last Updated 4 Jun 2012
Copyright © CodeProject, 1999-2014
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