Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 176
  • Last Modified:

How to modify a field sizes/type without deleting the field in the table in a Access database ?

How to modify a field sizes/type without deleting the field in the table in a Access database ?

Code PLS...

/Janne
0
jannea
Asked:
jannea
1 Solution
 
anthonycCommented:
not possible.
0
 
cymbolicCommented:
Anthonyc is right.  As such it its not possible, because Access does not support it.  However, a common method of acheiveing that result is to do the following:

Add a field to the table as you would like your resultant field to be.

Run an update query using the .execute method:
"Update MyTable Set NewField=OldField"

Then, delete the old field

After all, even if you could do it directly in Access, it wouldn't run any faster or better than doing it this way yourself.
0
 
janneaAuthor Commented:
Thanks...
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.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now