By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,442 Members | 1,332 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,442 IT Pros & Developers. It's quick & easy.

For a Field or Property object, this property is read/write until the object is appended to a collection or to another object, after which it's read-only

P: n/a
Hi Folk

I am working with the TYPE property. I want to change that from 2 (byte) to
4 (long integer) for a field that already contains tons of data. How can I
do that?

The help reads:

For a Field or Property object, this property is read/write until the object
is appended to a collection or to another object, after which it's
read-only.

So how can I un-append fix and re-append?

Cheers

- Nicolaas

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"windandwaves" <wi*********@coldmail.com> wrote in message
news:42********@clear.net.nz...
Hi Folk

I am working with the TYPE property. I want to change that from 2 (byte)
to 4 (long integer) for a field that already contains tons of data. How
can I do that?

The help reads:

For a Field or Property object, this property is read/write until the
object is appended to a collection or to another object, after which it's
read-only.

So how can I un-append fix and re-append?

Cheers

- Nicolaas


You could either create a new field with the required type, copy the data
into the new column with an update query, then delete the old column. I
believe this is the only approach if you are using the DAO object model.
You could try a data definition query - such as:
CurrentDb.Execute "ALTER TABLE MyTable ALTER COLUMN MyColumn INTEGER"
Which will turn it into a long integer.


Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.