Results 1 to 8 of 8
  1. #1
    Poohbear0471 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    63

    .mdb -> .accdb conversion

    Good morning, folks,

    We're getting ready to update from Office 2010 to Office 365. Once this is done, I'd like to update my older .mdb formats to .accdb. Are there any known problems I should watch out for when I do this?

  2. #2
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,993
    In most cases, the conversion will be painless though newer versions are less forgiving of poorly constructed code.
    Recommend you install 32-bit Office as there are no real advantages to using 64-bit Access.

    ACCDB files are far more secure so its worth changing for that alone

    Some features have been dropped including user level security, replication and pivot charts.
    There are many new features, not all of them good
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  3. #3
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,318
    I've had issues with an older calendar control that later versions of Access did not have. Only other thing I can think of is watch your Reference dlls, newer versions of Access will have different versions so people not running the later versions of Access might get errors.

  4. #4
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,754
    To add to Bulzie's comment, if you have a mix of Access versions among users, you might want to keep them as mdb's until all are the same. I probably wouldn't convert right away regardless, preferring to see how they perform as is. I agree with the bit comment - don't install 64bit Access. IIRC, 64 bit Office itself is more trouble than not.
    - "doesn't work" doesn't help. Implement changes in copies of your database.
    "Everyone has a photographic memory; some just don't have film." Steven Wright

  5. #5
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,993
    Further to the previous comments.
    1. The old calendar control was scrapped in A2010 and replaced with the date picker. There are alternatives if that isn't good enough for your needs.
    2. Always develop in the lowest version of Access that any of your users have.
    Version specific references (e.g. Excel 14.0) will be updated correctly for those with newer versions but not the other way round.
    Or use late binding to avoid having to load those references anyway.
    3. For file security reasons, I take the opposite view to Micron. I would convert to ACCDB but do so in A2010 (for the reasons stated above)
    4. The default installation is now 64-bit. If you have any APIs, installing that bitness will mean all API declaration will need to be modified. Lots of work & no benefit (in Access)
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  6. #6
    Micron is offline Virtually Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    6,754
    update my older .mdb formats to .accdb.
    By that I figured these were back ends, not front ends otherwise this would be about mde vs accde. Perhaps that's not the case. I sort of doubt that you would make back ends accde as well.

  7. #7
    isladogs's Avatar
    isladogs is offline Very idle programmer
    Windows 10 Access 2010 32bit
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    3,993
    Possibly so, but if these are BE files, all the comments about pivot charts, calendar controls, references etc are irrelevant
    Its also extremely unlikely that there would be any conversion issues.

    Some people do use ACCDE for BE files but I agree that doing so is utterly pointless

    Anyway, in my opinion, its just as important to convert the data file due to the hugely improved ACCDB file security over that in MDB files
    Colin (Mendip Data Systems) : Website, email
    If this has helped, please click the star button and leave a comment

  8. #8
    Poohbear0471 is offline Advanced Beginner
    Windows 7 32bit Access 2010 32bit
    Join Date
    Oct 2012
    Posts
    63
    Thanks everyone! I don't have any control over which version of Office we get. My stuff is just for my team. I won't convert my files until after we get our Office update, so everyone will have the same version. I think you answered all of my concerns and I greatly appreciate your input.

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

Similar Threads

  1. .accdb vs. .accdt
    By VAer in forum Access
    Replies: 9
    Last Post: 08-09-2018, 09:17 AM
  2. .accdb and .mdb
    By vruchtvet in forum Access
    Replies: 7
    Last Post: 05-27-2016, 04:05 AM
  3. ACCDB vs ACCDE
    By data808 in forum Access
    Replies: 8
    Last Post: 01-09-2014, 04:39 PM
  4. Access2010 accdb conversion to SQL
    By boss1b in forum SQL Server
    Replies: 9
    Last Post: 10-15-2012, 02:04 PM
  5. Replies: 3
    Last Post: 08-17-2012, 02:01 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
  •  
Tech Forums: Microsoft Office Forums