Results 1 to 2 of 2
  1. #1
    agent46 is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    May 2013
    Location
    Bay Area, Ca
    Posts
    12

    Combining records with attachments from separate computers into a master database

    We're a small shop building a modest database to keep track of our product listings on eBay. Two people on non networked computers are doing the data entry into cloned copies of our database. This includes attached photos for each record. At the end of each week, we want to combine the records created separately into the master database on my system.

    It seems like it would be simple enough to just cut and the paste the records from the two databases into the identical master. The problem I'm anticipating concerns the attached photos.

    I'm hoping some folks here could suggest strategies to transfer the records from the data entry computers to the master database while keeping the attached photos intact.

    Is there an effective, efficient way to set this up or would it be best to use the OLE format for the pictures instead of attaching them (which I prefer)?

    Many thanks in advance.

    ~46

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Replicating the attachment field requires VBA code. Review:

    http://blogs.office.com/b/microsoft-...cess-2007.aspx

    https://www.accessforums.net/program...ent-23686.html

    Saving images in database chews up file size. Access has a 2gb limit. I prefer to store images externally and only save file path in text field. Then I use Image control and set its ControlSource property to the text field.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 5
    Last Post: 03-30-2013, 12:56 PM
  2. Replies: 7
    Last Post: 02-25-2013, 10:01 AM
  3. Combining separate excel report data
    By mikebravo in forum Import/Export Data
    Replies: 7
    Last Post: 04-16-2012, 01:16 PM
  4. Replies: 5
    Last Post: 03-29-2012, 09:21 PM
  5. combining multiple tables in to one master
    By joebox8 in forum Queries
    Replies: 5
    Last Post: 06-23-2011, 06:18 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums