"Not Enough Memory" To Chg Text...

[Guest]

"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

 

[Douglas J. Steele]

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.

 

[Guest]

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

 

[Guest]

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

Thank you - Bob

 

[Guest]

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

 

[Pieter Wijnen]

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

 

[Guest]

Sounds good.

Thank you - Bob

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

 

[Pieter Wijnen]

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

Pieter

 

[Douglas J. Steele]

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

--
Doug Steele, Microsoft Access MVP

(no e-mails, please!)


"Pieter Wijnen"

 

[Pieter Wijnen]

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