Results 1 to 4 of 4

Opening Access 2003 Database from Access 2007

This is a discussion on Opening Access 2003 Database from Access 2007 within the Microsoft Access forums, part of the Question Forums category; Hey all, My company is updating piecemiel to Access 2007 - meaning I still have Access 2003, but some of ...

  1. #1
    New Member
    Join Date
    Mar 2006
    Location
    Seattle
    Posts
    31

    Exclamation Opening Access 2003 Database from Access 2007

    Hey all,
    My company is updating piecemiel to Access 2007 - meaning I still have Access 2003, but some of the company has 2007. I have a database I built a few years ago in Access 2003 that is used all across the company.

    The users that have updated to Access 2007 are reporting problems to me. Some people with 2007 can still use it but it is super slow, other users can't even open it.

    I don't know if I need to do something special to the database to make it compatable with 2007. And if I do update the database to 2007 format will the users still using access 2003 be able to open it?

    Help!

    Details - My database has a lot of macros, and 3 years worth of data. Would clearing out the data to only have a year in it help? (by creating an archive dump to get the size of the database down - Right now it is about 99 kb in size)

  2. #2
    MrExcel MVP
    Moderator
    SydneyGeek's Avatar
    Join Date
    Aug 2003
    Location
    Sydney, Australia
    Posts
    12,213

    Default Re: Opening Access 2003 Database from Access 2007

    Generally, opening an mdb database in Access 2007 is not an issue. I work with that format all the time.

    It is likely that your macros aren't running -- security settings in 2007 mean that many macro steps are disabled in 2007, unless you have put the database ni a trusted location. See if this sheds some light...

    Also, check out http://www.allenbrowne.com -- there is a good section on 2007 differences and issues.

    Denis
    Self-preservation: For when you've got yourself in a jam
    ------------------------------------------------------
    My site contains a number of Excel and Access Resources

  3. #3
    New Member
    Join Date
    Mar 2006
    Location
    Seattle
    Posts
    31

    Default Re: Opening Access 2003 Database from Access 2007

    Thanks. The links were very helpful. That seems to have fixed the problem for at least one person.

    Quote Originally Posted by SydneyGeek View Post
    Generally, opening an mdb database in Access 2007 is not an issue. I work with that format all the time.

    It is likely that your macros aren't running -- security settings in 2007 mean that many macro steps are disabled in 2007, unless you have put the database ni a trusted location. See if this sheds some light...

    Also, check out http://www.allenbrowne.com -- there is a good section on 2007 differences and issues.

    Denis

  4. #4
    New Member
    Join Date
    Oct 2006
    Posts
    14

    Talking Re: Opening Access 2003 Database from Access 2007

    Thanks!! This was very helpful

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


DMCA.com