<div>
Basic syntax:<br />
<a href="http://www.w3schools.com/sql/sql_alter.asp" rel="ugc">http://www.w3schools.com/sql/sql_alter.asp</a><br />
<br />

</div>


Basic syntax:
http://www.w3schools.com/sql/sql_alter.asp [http://www.w3schools.com/sql/sql_alter.asp]



<div>
Sorry ... meant to include this as well:<br />
<a href="http://www.devguru.com/Technologies/jetsql/quickref/alter_table.html" rel="ugc">http://www.devguru.com/Technologies/jetsql/quickref/alter_table.html</a>
</div>


Sorry ... meant to include this as well:
http://www.devguru.com/Technologies/jetsql/quickref/alter_table.html [http://www.devguru.com/Technologies/jetsql/quickref/alter_table.html]

<div>
Hi,<br />
<br />
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.<br />
<br />
Arnee.,<br />

</div>


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.,


<div>
Hi,<br />
<br />
Thanks I got the right help,<br />
<br />
Arnee
</div>


<div>
Hi Arnee,<br />
<br />
Where did you go to find the info?
</div>


Hi Arnee,

Where did you go to find the info?

<div>
Hi,<br />
<br />
I got the info from this site.<br />
<br />
<a href="http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp" rel="ugc">http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp</a><br />
<br />
Thanks again.,<br />
Arnee.<br />

</div>


Hi,

I got the info from this site.

http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp [http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dnacc2k/html/acintsql.asp]

Thanks again.,
Arnee.


<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
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).<br />
<br />
If its possible pls give me some samples or website link.,<br />
<br />
Arnee
</div>
</div>


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

ALTER Table thro SQL query in MS-ACCESS.

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.