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
--
JJ Runnion

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.

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


"JJ Runnion" <(E-Mail Removed)> wrote in message
news:FCB61458-86E0-438C-A6AB-(E-Mail Removed)...
>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
> --
> JJ Runnion
>

jj

Try this fix: http://support.microsoft.com/kb/286153/
--
Bill Mosca, Microsoft Access MVP


"JJ Runnion" wrote:

> 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
> --
> JJ Runnion
>

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.


--
JJ Runnion



"Bill Mosca" wrote:

> jj
>
> Try this fix: http://support.microsoft.com/kb/286153/
> --
> Bill Mosca, Microsoft Access MVP
>
>
> "JJ Runnion" wrote:
>
> > 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
> > --
> > JJ Runnion
> >

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.

--
Bill Mosca, Microsoft Access MVP


"JJ Runnion" wrote:

> 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.
>
>
> --
> JJ Runnion
>
>
>
> "Bill Mosca" wrote:
>
> > jj
> >
> > Try this fix: http://support.microsoft.com/kb/286153/
> > --
> > Bill Mosca, Microsoft Access MVP
> >
> >
> > "JJ Runnion" wrote:
> >
> > > 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
> > > --
> > > JJ Runnion
> > >