ALTER Table thro SQL query in MS-ACCESS.

Hello Experts,

Is it possible to ALTER A TABLE COLUMN's datatype or size present in MS-ACCESS data base with SQL query. I'm using MS access 2002 (version 10.2616.3311).

If its possible pls give me some samples or website link.,

Arnee
LVL 1
Arnee_SenthilAsked:
Who is Participating?
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Connect With a Mentor Infotrakker SoftwareCommented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
Arnee_SenthilAuthor Commented:
Hi,

Both links contains sample qry for ADD and DROP columns from ACCESS table. Is there any sample qrys available to MODIFY the column datatype or field length.

Arnee.,
0
 
Arnee_SenthilAuthor Commented:
Hi,

Thanks I got the right help,

Arnee
0
 
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
Hi Arnee,

Where did you go to find the info?
0
 
Arnee_SenthilAuthor Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.