Page 1 of 2 12 LastLast
Results 1 to 15 of 19
  1. #1
    DeeCee is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Location
    Auckland NZ
    Posts
    17

    Importing from Access 2

    I'm working on getting my Access 2 db into 2016. I have 2000, It successfully imported my tables, queries and macros, which I can then get into 2016, but it won't import any of my forms and reports. I've tried the conversion thing, but that won't work at all. If I could get the forms and reports in, even if they're broken, it would make my job a lot easier. Any ideas?



    I'm very much an amateur, but I put this together for my business in 95, and it's served me well since then.

    Cheers

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    51,338
    This article https://support.office.com/en-us/art...1-65d06bb12aa7 says should be able to import them into 2000. But then appear to need 2007 to do intermediate conversion.
    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.

  3. #3
    DeeCee is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Location
    Auckland NZ
    Posts
    17
    Quote Originally Posted by June7 View Post
    This article https://support.office.com/en-us/art...1-65d06bb12aa7 says should be able to import them into 2000. But then appear to need 2007 to do intermediate conversion.
    Cheers. Yes I've tried that route. The 2000 conversion attempt results in: "Microsoft Access failed to convert or enable your code modules" and "Your computer may be low on disk space or memory" (It's not)

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,131
    Post 3 was moderated, I'm posting to trigger email notifications.

    Welcome DeeCee; I've got a daughter in Wellington.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    DeeCee is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Location
    Auckland NZ
    Posts
    17
    Quote Originally Posted by pbaldy View Post
    Post 3 was moderated, I'm posting to trigger email notifications.

    Welcome DeeCee; I've got a daughter in Wellington.
    Cheers! No idea what your first sentence meant lol. Wellington just had a good shake! No reports of damage yet tho.

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,131
    Quote Originally Posted by DeeCee View Post
    No idea what your first sentence meant lol.
    The forum software moderated your post (because it contained a link and you're new), meaning nobody but a moderator could see it. When I approved it other members could see it but wouldn't have been notified that you had replied. I post so they get that notification.

    Yes, daughter said it scared the kids but no damage done. Whew!
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  7. #7
    GinaWhipp's Avatar
    GinaWhipp is offline Competent Performer
    Windows 7 64bit Access 2013 32bit
    Join Date
    Jul 2011
    Location
    Ohio, USA
    Posts
    378
    Have you tried to just convert it using Access 2000?

  8. #8
    DeeCee is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Location
    Auckland NZ
    Posts
    17
    Quote Originally Posted by GinaWhipp View Post
    Have you tried to just convert it using Access 2000?
    Cheers. Yes. The 2000 conversion attempt results in: "Microsoft Access failed to convert or enable your code modules" and "Your computer may be low on disk space or memory" (It's not)

  9. #9
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    51,338
    I never had to even try, but can you export forms, reports, code modules to bas files then import into the new db? https://access-programmers.co.uk/for...d.php?t=175459
    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.

  10. #10
    DeeCee is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Location
    Auckland NZ
    Posts
    17
    Quote Originally Posted by June7 View Post
    I never had to even try, but can you export forms, reports, code modules to bas files then import into the new db? https://access-programmers.co.uk/for...d.php?t=175459
    Hmmm, might be a bit beyond me. Cheers

  11. #11
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,458
    Have you tried opening a new database in 2000 and importing all objects to that?
    Then repeat from 2000 to a new database in 2007 and again from 2007 into 2016?

    If all else fails, I have every version of Access from Access 2.0 onwards on a VM.
    If you can zip and upload it, I will try and convert for you.
    Colin, MVP 2022, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

  12. #12
    DeeCee is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Location
    Auckland NZ
    Posts
    17
    Quote Originally Posted by ridders52 View Post
    Have you tried opening a new database in 2000 and importing all objects to that?
    Then repeat from 2000 to a new database in 2007 and again from 2007 into 2016?

    If all else fails, I have every version of Access from Access 2.0 onwards on a VM.
    If you can zip and upload it, I will try and convert for you.
    Cheers. I'm successfully doing that with tables, queries and macros, got them all up and running in 2016, by importing to 2000, then importing to 2016. If I try to import any or all reports or forms into 2000 I get "Microsoft Access failed to convert or enable your code modules"

    I appreciate your offer. How do I get the 808kb zip file uploaded?

  13. #13
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    51,338
    Follow instructions at bottom of my post.
    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.

  14. #14
    DeeCee is offline Novice
    Windows 7 64bit Access 2016
    Join Date
    Oct 2018
    Location
    Auckland NZ
    Posts
    17
    Cheers. Hope this worked HARVFRON.zip (807.1 KB
    Attached Files Attached Files

  15. #15
    isladogs's Avatar
    isladogs is offline MVP / VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    5,458
    All done. Hopefully the attached is what you wanted

    2 things slowed me down a bit:
    1. Not having any of the linked tables
    2. Not having a default printer on my VM with Access 2000 - I had to fake a printer to open the file!

    These are the steps I did using various versions of Access:
    1. I opened it in Access 2 so I knew that was the file format
    2. Reopened in A2000 and converted the format
    3. Reopened in A2010 and converted to ACCDB - removed the utility.mda reference which doesn't exist in ACCDB files
    4. Reopened in A2016 so the references updated - otherwise should be identical to 2010 version

    Due to not having all the linked tables, I can't really check its OK. I need to leave that to you

    I'm attaching all 3 converted versions in case you have problems with any of them
    Let me know whether it seems OK & I'll then delete all files from my PC
    Attached Files Attached Files
    Last edited by isladogs; 10-31-2018 at 04:53 PM.
    Colin, MVP 2022, Website, email
    The more I learn, the more I know I don't know. When I don't know, I keep quiet!
    If I don't know that I don't know, I don't know whether to answer

Page 1 of 2 12 LastLast
Please reply to this thread with any new information or opinions.

Similar Threads

  1. Importing .WDB into Access
    By walpy in forum Access
    Replies: 2
    Last Post: 01-23-2014, 12:14 PM
  2. Importing data from PDF to Access
    By jigg14 in forum Import/Export Data
    Replies: 1
    Last Post: 02-10-2012, 12:57 AM
  3. automate importing access
    By mcchung52 in forum Access
    Replies: 1
    Last Post: 01-21-2012, 02:20 AM
  4. Importing XML to Access
    By herbc0704 in forum Import/Export Data
    Replies: 1
    Last Post: 06-02-2011, 04:30 PM
  5. Importing Txt file to Access
    By fuxy in forum Access
    Replies: 6
    Last Post: 04-25-2011, 07:58 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