Results 1 to 6 of 6
  1. #1
    PeteMorrison is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    9

    Moving an access 2010 database to a distant free standing un-networked desktop


    I was hoping I could just attach an Access 2010 .mdb file that I am creating and attach it to an email for my sister to use on her desktop. She also has Access 2010. Now I understand that won't work because the my database contains references to the folders on my desktop.
    In no way will the data need to be shared between the different computers.
    I'll be sending blank tables and forms that I created. She will be putting in her own records.
    It seems like this would be a common problem, but finding an answer has been a nightmare.

    Thank you for any help you can offer.
    Pete Morrison

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    Is your db still unsplit (all in one db)? What folders on your desktop are you referencing? Have you tried it yet?
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  3. #3
    PeteMorrison is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    9
    Quote Originally Posted by RuralGuy View Post
    Is your db still unsplit (all in one db)? What folders on your desktop are you referencing? Have you tried it yet?
    I'm a bit new to this, so forgive me. When I spoke of my desktop, it was what I call my desktop computer. The database won't be split. I will keep my complete copy here to help support her and her complete copy if she has problems in Florida. I had been told recently on another forum, that my Database contained code references to C:\Users\Pete\Documents etc... that she would not have on her computer so it wouldn't work.
    If that is not typically used, I was misinformed. I'd love to be able to save what I have and bring it down there and install it on her system.

    Thanks very much for the quick reply. PS I enjoyed your teaching quote. I also have a rural brother in Colorado. He's in Conifer, near Evergreen.

    Pete

  4. #4
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    Without seeing the db I would guess that you could send it to Florida and it would work just fine. Do a Compact and Repair and then Zip it up and email it to Florida and try it.
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

  5. #5
    PeteMorrison is offline Novice
    Windows 7 64bit Access 2010 32bit
    Join Date
    Dec 2012
    Posts
    9
    Thanks very much.
    Pete

  6. #6
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 7 64bit Access 2010 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,912
    Post back to this thread if it doesn't work as expected. Happy New Year!
    (RG for short) aka Allan Bunch Previous MS Access MVP - WinXP Pro, Win7 Pro Win10 Pro - acXP, ac07, ac10, ac13
    How to mark the thread as Solved!
    Teaching is not filling a bucket but lighting a fire.
    Borrowed quote..."Docendo discimus"

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

Similar Threads

  1. Moving Access Database
    By midpitts in forum Access
    Replies: 3
    Last Post: 12-04-2012, 05:32 PM
  2. Replies: 16
    Last Post: 06-21-2012, 10:00 PM
  3. Replies: 0
    Last Post: 06-19-2012, 12:39 PM
  4. Replies: 6
    Last Post: 02-18-2012, 07:20 AM
  5. Replies: 3
    Last Post: 10-15-2010, 04:23 PM

Tags for this Thread

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 - Senior Forums