Data type error

[Guest]

I have a user who keeps getting an error "Microsoft Office Access can't
change the data type. There isn't enough disk space or memory."

Win2000 using Office 2003 and 1GB RAM with 23GB free disk space.
I ran the task manager to monitor memory usage and it never got about 20%
for either logical or physical memory.

The db has about 15 tables, no more than 50 fields in any, and the total
size is about 83Mb.

Assistance will be appreciated!

jj

 

[Douglas J. Steele]

No guarantee that it'll work, but try adding a new field (rather than
changing the existing field), run an update query to populate the new field,
delete the old field, rename the new field to the old field name, then
compact the database.

 

[Guest]

jj

Try this fix: http://support.microsoft.com/kb/286153/

 

[Guest]

thanx. i did try to set the MaxLocksPerFile to 19000 to see if that will
solve the problem. I wonder if this is a design issue (should he have broken
the fields up into more tables)?

I'm not an Access person, mostly generic IT applications ... system and
such, so i appreciate your input.

 

[Guest]

JJ

I don't think breaking up the tables will help. A table can have up to 255
fields. Most likely it's the number of records that you are manipulating.