Results 1 to 12 of 12
  1. #1
    Join Date
    Feb 2009
    Posts
    49

    Unanswered: migrating access database 2003 to access 2007

    Hi

    I have a tasks from my boss, which is to migrate the databases made from ms access 2003 to ms access 2007.

    I'm not really sure what to do first as I'm very new to databases and access as well.

    Does anybody have any idea where I can find some tutorials about this?

    Another thing is: my boss also don't want to have the ribbon bars to be seen by the user. He forwarded me some example database which I think also comes from Microsoft. I'm not sure if you're familiar with the Charitable Contributions Database. If you open this to ms access, it usually have the option above asking you to deactive/activate the macro.

    He wanted that our ms access databases will also be like that as the end output and at the same time will work.

    I'll appreciate any of your ideas and help.

    Thanks

  2. #2
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  3. #3
    Join Date
    Feb 2009
    Posts
    49
    hi

    thanks for the reply. actually I have this link already.

    I tried to migrate a simple database now to ms access 2007.

    what i did, was I convert the .mdb file format to .accdb file using the ms access 2007.
    and then i opened it and I added the trust locations.

    what happen now when I opened the converted file is, I'm getting an error which says: " INI-Datei can't be found. This application will be closed".

    And then I can't open my database now.

    I'm not really sure what's happening here. I've been trying this since 3 weeks ago.

    Do you need to convert the .mdb file in order for it to work in ms access 2007? It says you don't need to convert, but the problem is, if I don't convert the other tables and forms are not working anymore.

    Do you have any idea about the charitable contributions database?

  4. #4
    Join Date
    Oct 2002
    Location
    Leicester - UK
    Posts
    820
    unfortunately not,

    i tend to work on databases that access doesn't have the power to support, so my knowledge of the ins and out of access is a little out of date and that isn't an error that i've received

    as for the scrolling marque you will probably find it was purchased as an extra feature from a 3rd party, you could do a basic one my using a macros to chop the first letter off of a string and add it to the end but it wouldn't look particularly good, but if you want to try that then explored VB's left and right function

    or you can purchase a 3rd party control a quick google turns up
    Microsoft Access Scrolling Marquee Text for Your Access Forms
    Definition of a Beginner, Someone who doesn't know the rules.

    Definition of an Expert, Someone who knows when to ignore the rules.

  5. #5
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    You shouldn't need to do a thing. Access 2007 can open and work with previous file format (not '97) files without touching them. They will continue to behave as they did in the previous versions.

    What happens if you try that?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  6. #6
    Join Date
    Dec 2004
    Location
    Madison, WI
    Posts
    3,926
    I'm guessing you have some code which 2007 doesn't like (or even a reference). I'm having difficulties upsizing some 2003 mdb's to 2007 due to the vba code used which 2007 doesn't like very well.
    Expert Database Programming
    MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)

  7. #7
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    I am sooooooo thankful that I haven't run into such problems!
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  8. #8
    Join Date
    Jun 2005
    Location
    Richmond, Virginia USA
    Posts
    2,763
    Provided Answers: 19
    Allen Browne has an excellent page covering converting to 2007 with the pitfalls, thigs to be aware of, code that will not run. Towards the bottom he also gives a huge list of links to others pages dealing with it.

    Microsoft Access tips: Converting to Access 2007
    Hope this helps!

    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

  9. #9
    Join Date
    Feb 2009
    Posts
    49
    thanks for the replies. if I opened the .mdb file ms access 2007 I'm getting an error, "Ini Application can't be found or something"...

    and the thing is, we would like to get rid of the ribbons and would like to use the toolbars we have from the ms access 2003. i'm not really sure if that's possible.

  10. #10
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    we would like to get rid of the ribbons and would like to use the toolbars we have from the ms access 2003. i'm not really sure if that's possible.
    If you want the 2003 functionality, why upgrade to 2007??

    If you don't update the database file format (ie if you do NOTHING) then you will get what you want.
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

  11. #11
    Join Date
    Feb 2009
    Posts
    49
    hi StarTrekker, I think you misunderstood my question.
    the ribbon bars are quite confusing for the user, in ms access 2003, we have created the menu bars that we wanted to be displayed, when the user work on the file. that means, if they work with open, save, and copy functions all the time, these are then, present the first time they open the file.

    I would appreciate it if you could give your idea.
    thanks

  12. #12
    Join Date
    Nov 2007
    Location
    Adelaide, South Australia
    Posts
    4,049
    So,.... what... the toolbars you want to use are in a new Access 2003 file (MDB) and you want to apply them in your Access 2007 file (ACCDB)?
    Owner and Manager of
    CypherBYTE, Microsoft Access Development Specialists.
    Microsoft Access MCP.
    And all around nice guy!


    "Heck it's something understood by accountants ... so it can't be 'that' difficult..." -- Healdem
    "...teach a man to code and he'll be frustrated for life! " -- georgev

Posting Permissions

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