"Not Enough Memory" To Chg Text...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Bob Barnes - 16 Sep 2007 21:22 GMT

"Field Size" from 12 to 14...on a Thin Client administered
by another Company...Access 2003.

I've left a message for the Company.

Any ideas why?

TIA - Bob

Reply to this Message

Douglas J. Steele - 16 Sep 2007 23:07 GMT

How big is the database currently? Even though it may seem like a small
change, Access actually creates a new field, transfers the data to that new
field then deletes the old field.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no private e-mails, please)

> "Field Size" from 12 to 14...on a Thin Client administered
> by another Company...Access 2003.
[quoted text clipped - 4 lines]
>
> TIA - Bob

Reply to this Message

Bob Barnes - 17 Sep 2007 00:36 GMT

Doug - I just called the guy (and left a message)..I might not get the answer
until tomorrow, but will Post it here then.

Thank you - Bob

> How big is the database currently? Even though it may seem like a small
> change, Access actually creates a new field, transfers the data to that new
[quoted text clipped - 8 lines]
> >
> > TIA - Bob

Reply to this Message

Bob Barnes - 17 Sep 2007 20:08 GMT

I asked the Company twice for this info, but they haven't replied...probably
means the Network Admin resolved the problem.

Thank you - Bob

> Doug - I just called the guy (and left a message)..I might not get the answer
> until tomorrow, but will Post it here then.
[quoted text clipped - 13 lines]
> > >
> > > TIA - Bob

Reply to this Message

Bob Barnes - 17 Sep 2007 21:28 GMT

The Back-end, compacted, is 225,768 KB.

When trying to change a text Field Size from 12 to 14, it says Not enough
disk space or not enough memory. The Network Admin is telling to Company to
convert to SQL Server...

Any ideas?? TIA - Bob

Reply to this Message

Pieter Wijnen - 17 Sep 2007 21:33 GMT

Take a Backup

Compact The Database
Create an Empty Copy of The Table
Fix The Field Size
Append All The Data
Delete the Old Table
Rename The New Table
(Restablish Relations)
Compact The Database

HTH

Pieter

> The Back-end, compacted, is 225,768 KB.
>
[quoted text clipped - 18 lines]
>> >
>> > TIA - Bob

Reply to this Message

Bob Barnes - 17 Sep 2007 23:08 GMT

Sounds good.

Thank you - Bob

> Take a Backup
>
[quoted text clipped - 33 lines]
> >> >
> >> > TIA - Bob

Reply to this Message

Pieter Wijnen - 18 Sep 2007 02:30 GMT

I've always suspected Jet (Access) to do a bit of cut & paste type of thing
when doing this - any thoughts?

Pieter

> Sounds good.
>
[quoted text clipped - 41 lines]
>> >> >
>> >> > TIA - Bob

Reply to this Message

Douglas J. Steele - 18 Sep 2007 12:25 GMT

Sort of, although I suspect it's more an update query than an actual
copy-and-paste.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> I've always suspected Jet (Access) to do a bit of cut & paste type of
> thing when doing this - any thoughts?
[quoted text clipped - 46 lines]
>>> >> >
>>> >> > TIA - Bob

Reply to this Message

Pieter Wijnen - 19 Sep 2007 00:26 GMT

To be more specific a sort of transaction, as it "rolls back" on failure.
Haven't attempted it myself since Access 2.0 <g>

Pieter

> Sort of, although I suspect it's more an update query than an actual
> copy-and-paste.
[quoted text clipped - 49 lines]
>>>> >> >
>>>> >> > TIA - Bob

Reply to this Message