"Out of String Space" Error message.

[PaulChilds]

Hi,

I'm creating a simple DVD cataloging database.

Included is a subform which will have the names of the cast and crew made of three columns: Actors, Director(s) and Composer(s). When I go to put a name in the first column I get a pop up "out of string space message". Then everything seems to work fine, but if I go back into the record, all but the top line of the subform have been deleted.

Any ideas?

http://www.worship-leader.co.uk

http://www.liverpooldream.co.uk

http://www.ormskirkparish.co.uk

http://www.cadetsltd.co.uk

 

[PaulChilds]

Any ideas on this one? It's not been solved yet.

http://www.worship-leader.co.uk

http://www.liverpooldream.co.uk

http://www.ormskirkparish.co.uk

http://www.cadetsltd.co.uk

 

[PaulChilds]

I don't know if this helps, but it does it on one of my machines, but not another. Both are PIII, both are Win2K and both are Access version 2K - so why should there be a difference?

http://www.worship-leader.co.uk

http://www.liverpooldream.co.uk

http://www.ormskirkparish.co.uk

http://www.cadetsltd.co.uk

 

[missinglinq]

The "out of string space" is usually a system problem as opposed to an Access problem. In simple terms it means that your computer has run out of the memory space needed to store the given string. Your datahasn't been "deleted", it's never been entered in your table.

My guess is you've probably got some program(s) running in the background, using up memory, on the machine that is having problems. Is this is the cause you may need to find the program(s) and disable them while you run you db or you could go into your config.sys file and change your buffer settings. You should see a line like "buffers=40". Try increasing this number.

You say it's a simple database. Does it use VBA code? Sometimes in writing code you can accidentally create an endless loop which could also cause your computer to run out of space by trying to write the same data to the db over and over again. This would require debugging your code looking for the loop.

Hope this helps.

The Missinglinq

"It's got to be the going,
not the getting there that's good!"
-Harry Chapin

 

[PaulChilds]

I don't appear to have a config.sys file. I've searched all over for it but can't find it. Any ideas?

http://www.worship-leader.co.uk

http://www.liverpooldream.co.uk

http://www.ormskirkparish.co.uk

http://www.cadetsltd.co.uk

 

[MakeItSo]

It happens at the moment you try to type something in?
Sounds like an Access problem, although I never encountered one like this.
Do you have any code in the Change event of the textfield you use for entering?
Besides: "When I go to put a name in the first column"

What have you put on this subform for data entry anyway?
Textboxes? List boxes?
In the latter case, you might receive problems...



Andreas Galambos
EDP / Technical Support Specialist
(andreas.galambos@bowneglobal.de)
HP:

http://www.andygalambos.de

 

[PaulChilds]

Missinglinq is right - it's not a problem with the database or the software, it's a problem with the machine's memory.

Can't seem to get it to work on one of my machines, but another one I have (Win 98 350mhz, 256mb) works fine.

http://www.worship-leader.co.uk

http://www.liverpooldream.co.uk

http://www.ormskirkparish.co.uk

http://www.cadetsltd.co.uk