Results 1 to 5 of 5
  1. #1
    Join Date
    Jun 2011

    Unanswered: Multiple problems adding data to db

    Access 2000 with 20K records and photos. Peer to peer network with Win XP SP3. Have had a problem with this db for a while now, three techs have given up… could be Access, networking or combination of both problem. Each data form has a photo attached of the item (museum artifact db). However, at this time the individual photos are not showing up on the forms, the same photo is showing up in each form. In the past this worked correctly. The db and the related photo file reside on the C drive of the main museum collection’s department computer. Two other computers on the network have had the ability to update records in the past. The last tech attempted a fix by placing the db files and photo file on a virtual drive F. Now, the photo problem remains the same, and we can add data from the other machines in Table view but not in Form view. Other pcs on the network need to read only from their locations. Have loaded Office 2010 but have not tried to import db yet as it could make the problem worse.
    Last edited by johnnywyoming; 06-10-11 at 10:39. Reason: non-descriptive thread title

  2. #2
    Join Date
    May 2004
    New York State
    There's something missing in your description. Are the data files and photo file related? Or at least JOINed as the recordsource for your form?


  3. #3
    Join Date
    Jun 2005
    Richmond, Virginia USA
    Provided Answers: 19
    Also, is this Multi-User app properly split into a front end/back end configuration?

    Unsplit Multi-User apps can runs fine for extended periods of time then suddenly start exhibiting all kinds of problems.

    And once this starts the problems become chronic until the app is split.

    Linq ;0)>
    Hope this helps!

    The problem with making anything that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  4. #4
    Join Date
    Feb 2004
    New Zealand
    Provided Answers: 5
    Dumb Question

    Is the database pointing to the Photos that are on the server.

    ie [feildname] and its value is \\servername\foldername\photo.jpg

    or is it

    [feildname] and its value is F:\foldername\photo.jpg

    it its pointing to F:\ is the User computer have the Drive map.

    could you show us the Code display the Image

    the code should look some like

    Me.pictureobject = LoadPicture(Me.thefeildname)
    hope this help

    See clear as mud

    StePhan McKillen
    the aim is store once, not store multiple times
    Remember... Optimize 'til you die!
    Progaming environment:
    Access based on my own environment: DAO3.6/A97/A2000/A2003/A2007/A2010
    VB based on my own environment: vb6 sp5
    ASP based on my own environment: 5.6
    VB-NET based on my own environment started 2007
    SQL-2005 based on my own environment started 2008

  5. #5
    Join Date
    Jun 2011
    Sorry guys, your questions and comments are mostly over my head. I do not believe that the db is split front and back, but it sounds like it should be. The db and photos are on the same computer. As far as how they are connected I believe there is a command in the photo box to tell it where to go to find the correct photo. I did find another tech who is Access savvy so hopefully that will do the trick.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts