Results 1 to 3 of 3
  1. #1
    duncan cameron is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    2

    Save a access 2010 db as 2007 db

    Hi,



    I have a db in access 2010 (used to be 2007). The invoice report works OK if opened in 2007, but not in 2010. Now I would like to save the 2010 file as 2007 to see if the invoice report will still work OK. The 2010 file was password protected and would not let me save as until the password was removed. I have now been able to remove the password, but still cant save it in 2007 format.

    I just installed Access Professional 2010 and the report works fine. So, no idea why it does not work in access 2010 non professional. Access 2010 is used by the Community Association and I am trying to help them get the Invoice Report to work correctly. In the report the $ amounts are showing as #Type or # error(only in 2010)

    Thanks

    Duncan

  2. #2
    help_me_with_access is offline help_me_with_excel
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    262
    if you have save these files in 2010, absolutely do not open them in an earlier version. more than likely they will become corrupted. 2010 operates under a different architecture than the previous versions. especially the macro objects. could that possibly be the issue here? I don't believe that problem has been resolved yet but I have not researched it for quite some time.

  3. #3
    duncan cameron is offline Novice
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2012
    Posts
    2
    Hi,

    Thanks for responding.

    I will let the person responsible that the 2010 file can not be saved as a 2007 file.

    I will try to figure our why the dollar amounts come up with the errors and hopefully get it to work in 2010 for them.

    I just find it strange that the code works in 2007 and in my 2010 professional but not on 2010 standard.

    Thanks

    Duncan

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

Similar Threads

  1. Replies: 0
    Last Post: 07-31-2012, 12:25 PM
  2. Save Access 2010 as .SQL
    By rthomaskelly in forum Access
    Replies: 1
    Last Post: 04-01-2012, 03:37 PM
  3. mdb save problems with Access 2010
    By pacnwWill in forum Programming
    Replies: 3
    Last Post: 09-27-2011, 11:52 AM
  4. Auto Save MS Access 2007
    By BlindLady in forum Access
    Replies: 2
    Last Post: 02-27-2011, 06:44 AM
  5. Access db, save as 2003 to 2007
    By laavista in forum Access
    Replies: 2
    Last Post: 06-02-2010, 07:58 PM

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