Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here


"Out of String Space" Error message.

"Out of String Space" Error message.

"Out of String Space" Error message.


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?


RE: "Out of String Space" Error message.

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

RE: "Out of String Space" Error message.

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
HP: http://www.andygalambos.de

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close