"Not Enough Memory" To Chg Text...

B

Bob Barnes

"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
 
D

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.
 
B

Bob Barnes

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
 
B

Bob Barnes

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

Thank you - Bob
 
B

Bob Barnes

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
 
P

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
 
B

Bob Barnes

Sounds good.

Thank you - Bob

Pieter Wijnen said:
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
 
P

Pieter Wijnen

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

Pieter
 
D

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"
 
P

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
 
Top