How to modify field size in access DB whit DAO ?

Hello,

I did not found how can I modify the size of a field in a access database wiht DAO (3.5) unsing VC++ 5.0. I hope that someone has did it already.

It is quite urgent,
Thank you in advance,
Cataldo

cursoAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

cursoAuthor Commented:
Edited text of question.
0
cursoAuthor Commented:
Edited text of question.
0
abancroftCommented:
What exactly do you need to do? e.g. Make a string field wider?
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

Anju111599Commented:
CDaoRecordSet::m_pDatabase is a pointer to the underlying database object.  You can use that to access the CDaoTableDef object for the table you want to modify.  This web page has the details:

http://msdn.microsoft.com/library/devprods/vs6/visualc/vcmfc/_mfc_cdaotabledef.htm

Anju
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
inprasCommented:
Hi Anju
And How he does that?
Altering a perticular column? using tabledef?
0
cursoAuthor Commented:
Precision:

I need to increase the size of text field in a access database (which is already dissaminated). I can not replace the old database with new database, I must upgrade the old to keep data and keep integrity constraints.
I wish avoid to recreate the field (new column, copy data, delete old, renanme new delete the temp column).

Are sure that possble using CDaoTableDef object, I did not see any method to change size?

Cataldo
0
Anju111599Commented:
I'll write some test code later tonight and post it for you.

Anju
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
C++

From novice to tech pro — start learning today.