Results 1 to 4 of 4
  1. #1
    Vera is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Location
    Belgium
    Posts
    9

    Convert access 2003 to access 2010

    I'm planning a conversion of access 2003 to access 2010 and I wonder if there are already known issues that will cause problems in the corresponding VBA code.
    I have knowledge of the calender ocx, but I'm sure there are a lot more and I wonder if there is a list.
    Any known issues are welcome. Thanks



    Vera

  2. #2
    DaveT is offline Access Developer
    Windows 7 Access 2010 (version 14.0)
    Join Date
    May 2010
    Location
    Texas
    Posts
    69
    I'd look at the conversion issues to 2007 first since 2007 and 2010 are close cousins and the biggest changes were from 2003 to 2007.

    Migration considerations (to 2007):
    http://technet.microsoft.com/en-us/l...ffice.12).aspx

    Converting to 2007:
    http://allenbrowne.com/access2007.html


    The 2007/2010 UI is significantly different from 2000/2002/2003, so expect a learning curve for sure.

    The first hurdle is usually the trusted issue: VBA, some macros won't run unless you "trust" all macro actions or set specific trusted locations (folders).

  3. #3
    NTC is offline VIP
    Windows Vista Access 2007
    Join Date
    Nov 2009
    Posts
    2,392
    here are tips for conversion to 07:
    http://allenbrowne.com/Access2007.html#Bugs

    but honestly the key thing is simply to open the db and run it in 2010 - - in .mdb format with no formal 'conversion' to .accdb format. most things that might not work are simply fixed by remaking the object (i.e. a command button that doesn't work or something like that).

    only convert to .accdb format if you need features unique to this format; such as rich text or multivalue fields or whatever....

  4. #4
    Vera is offline Novice
    Windows XP Access 2003
    Join Date
    Jul 2010
    Location
    Belgium
    Posts
    9
    Thanks for the input.

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

Similar Threads

  1. Access 2010
    By Desstro in forum Access
    Replies: 8
    Last Post: 01-19-2016, 04:09 PM
  2. Insert Image in Access 2010 ???
    By cowboy in forum Access
    Replies: 5
    Last Post: 03-18-2014, 08:22 AM
  3. 2007 Access DB won't work in 2010 - 64 bit
    By InvGrp in forum Access
    Replies: 2
    Last Post: 07-12-2010, 08:45 AM
  4. MS Access 2007 vs 2010
    By ralphjramirez in forum Access
    Replies: 2
    Last Post: 05-06-2010, 06:30 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