Contact US

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!

*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

Different repair method needed for error 1035 in PP field

Different repair method needed for error 1035 in PP field

Different repair method needed for error 1035 in PP field

I have tried the memo field repair method for the picture plus field problem I have, which involves saving the offending record, deleting it, and the re-importing it.It worked the first time, but when the problem happened again, the same fix doesn't work.

Re-linking the picture to the source file is quite cumbersome.  As I said before, I had to move the dbf, dbt, and apr files from one disk to another.  In the process, I changed the relative positions of the files and folders.  At first, the photos showed up in the files just fine.  When I double clicked on them to open the picture in MS Paint, the message OLE server busy displayed.  I went through almost 700 records and went to edit, picture, import, and then selected the picture file to go with the record.  Even though it is the same picture as before, double clicking it produced no error message.  To get the source photo to open in MS Paint, I had to go to create object, bitmap, object, link to file, browse for file. The linked photo appears in the PP field, and the source picture opens in MS Paint.  When I try to move to the next record, that is when the failure to update the database error occurs (-1035).

This project I am working on is about trees, but computers have already delayed it for weeks.  Please help.

RE: Different repair method needed for error 1035 in PP field

The -1035 error means that the .DBT file has reached its limit of 2GB. This cannot be changed. You cannot add more pictures to your database.

One alternative is to store the pictures in separate files and display them on forms with a script. This technique is shown by example in the XpertSS Free Downloads "APR-PIC" item.

Go to http://www.xpertss.com/webdata/freebies_search.html and enter "picture" in the title field to search for this example.

Sue Sloan

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