Results 1 to 6 of 6
  1. #1
    two_smooth's Avatar
    two_smooth is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    19

    Cool MS Access 2003 to MS Access 2007

    Team,



    How do I get a database that was created in MS Access 2003 to display and function properly in MS Access 2007?

    Peace,

    two_smooth

  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,110
    Have you tried it? I run a number of 2000 mdb's on PC's with 2007, and they run fine.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    have done alot of 03 - 07....sometimes they run fine with no issue at all. sometimes even users have moved to 07 without even telling me.....but othertimes there is code that barfs; I've not really seen a consistent reason to it...you just kind of have to work thru the issues case by case; if you are implying your's won't run at all - then one would guess you have an event firing upon open that needs to be tweaked or possibly you haven't set up the trust center parameters....

  4. #4
    two_smooth's Avatar
    two_smooth is offline Novice
    Windows XP Access 2003
    Join Date
    Feb 2010
    Posts
    19

    MS Access 2003 to MS Access 2007

    Quote Originally Posted by NTC View Post
    have done alot of 03 - 07....sometimes they run fine with no issue at all. sometimes even users have moved to 07 without even telling me.....but othertimes there is code that barfs; I've not really seen a consistent reason to it...you just kind of have to work thru the issues case by case; if you are implying your's won't run at all - then one would guess you have an event firing upon open that needs to be tweaked or possibly you haven't set up the trust center parameters....
    I did get the MS Access 2003 to function in MS 2007. Everything worked fine except the switchboard buttons for various reports. When I looked at the reports in either the design or print preview views, I get the following error message, " There was a problem retreiving printer information for this object. The object may have been sent to a printer that is unavailable". What's even stranger is that I opened the MS Access database on three different laptops (two with MS Access 2003 and one with MS Access 2007) and one of the Laptops with MS Access 2003 and one with MS Access 2007 displayed the above error message. What's causing this error message?

  5. #5
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,110
    For starters, I would make sure a printer is defined on each machine.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  6. #6
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    opening an Access Report triggers the printer driver for some reason that I don't fully understand. but I am certain on this point....a bad priinter driver (or a missing printer?) will impact your ability of open a Report even in preview mode..... not sure if there is a work around as now that I type this - it certainly is a hassle for laptops.....

    if it was just happening on the 07 - I would say to just remake the buttons that don't work - - - but it sounds like it is happening in both 03 & 07 so I would double check them when there is a printer attached and see ....

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

Similar Threads

  1. Access 2007 and Access 2003
    By emont in forum Access
    Replies: 5
    Last Post: 01-12-2010, 12:50 PM
  2. 2007 MDE will not Open in Access 2003
    By wmecook in forum Programming
    Replies: 4
    Last Post: 12-01-2009, 05:15 PM
  3. Replies: 6
    Last Post: 12-01-2009, 11:59 AM
  4. Access 2003 plus Access 2007
    By genesis in forum Access
    Replies: 2
    Last Post: 10-13-2009, 07:24 PM
  5. converting from Access 2003 to Access 2007
    By LawrenceLau in forum Access
    Replies: 6
    Last Post: 11-20-2008, 03:53 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