Monday, August 31, 2009

MSACCESS --- ADD BOOLEAN(YES/NO,CONTROL)FIELD PROGRAMMATICALLY

Hello friends

Some times its a bit difficult to add columns in msaccess tables

Here is an example

How to alter msaccess table programmatically

Adding boolean(yes/no,control)field

Alter table add column bit

This will add control field or boolean field or yes/no field in msaccess table


MSACCESS --- HOW TO ADD IDENTITY COLUMN PROGRAMATICALLY

HELLO FRIENDS
SOME TIMES ITS A BIT DIFFICULT TO ADD COLUMNS IN MSACCESS TABLES
HERE IS AN EXAMPLE
HOW TO ALTER MSACCESS TABLE PROGRAMMATICALLY
ADDING IDENTITY COLUMN
ALTER TABLE ADD COUNTER