Results 1 to 5 of 5

Thread: Migrating access 2000 - 2007

  1. #1
    Join Date
    Nov 2009
    Posts
    518

    Migrating access 2000 - 2007

    Hello,
    I tried to do some research but I think I need it explained to me directly. The small company I belong to what is about to migrate all these Office 2000 to 2007 so much to catch up on old licenses out , we can not do without the base that I developed, the .mdb file developed in Access 2000 with many formulas, queries, macros, and even if I am a quiche in VBA, modules and vb behind events. This does not work when it opens with access 2007. Is there a way to easy conversion to put "update" my database? I do not know the runtime , this allows it to be free of any license access (or other?) on the client? Your help will be valuable for me.
    Last edited by GlassFish; 22-12-2009 at 11:27 AM.

  2. #2
    Join Date
    May 2008
    Posts
    4,345

    Re: Migrating access 2000 - 2007

    Hello
    the .mdb file developed in Access 2000 with many formulas, queries, macros, and even if I am a quiche in VBA, modules and vb behind events. This does not work when it opens with access 2007.
    What does not? The application opens it and it works fine.
    I do not know the runtime , this allows it to be free of any license access (or other?) on the client?
    The runtime can actually deploy the application without a specific license.

  3. #3
    Join Date
    Nov 2009
    Posts
    518

    Re: Migrating access 2000 - 2007

    Hi
    The application is launched but I have a starter modules that do not run or evil.
    Before going into detail, I was wondering if there was a conversion tool. Also all my macros with "SetValue" are blocked by default. To the runtime, is there a "runtime license" to acquire? Is it easy to implement? I am really confused about what to do now. Any help will be highly appreciated.

  4. #4
    Join Date
    May 2008
    Posts
    4,345

    Re: Migrating access 2000 - 2007

    Hello
    It must be going again a compilation of the code, after it is finished see if the references are good. Debugging you will be reporting errors. You can certainly use Access 2007 with MDB files. If you converted the Accdb you can enjoy the full functionality of Access 2007 but you can no longer read with earlier ersions. Anyway with a backup is no harm in trying. For the runtime 2007, the only thing to do is download and install it. There is usually not too difficult for applications except for possible contextual menus. By cons, it must be shielded error handling, because there is risk of a crash with no explanation as the sole remedy. Hope this will help you.

  5. #5
    Join Date
    Nov 2009
    Posts
    518

    Re: Migrating access 2000 - 2007

    Hi
    And that's when my computer is revealed weakness as such! I can compact a database, but not compile the vba. Can you give me the procedure? I just found it is in the vba window / debug. To the runtime, is there another advantage to work together? Please help me with this, I have lost a lot of my time in searching this on internet and I should solve this now. Thank you.

Similar Threads

  1. Advantages of Migrating from Microsoft Access to MySQL
    By PsYcHo 1 in forum Windows Software
    Replies: 5
    Last Post: 27-03-2010, 12:58 AM
  2. Access database error 800a0cb3 after migrating server
    By Wyvern in forum Software Development
    Replies: 3
    Last Post: 31-10-2009, 06:26 PM
  3. Migrating from SBS 2000 to SBS 2008
    By BlackSunReyes in forum Small Business Server
    Replies: 3
    Last Post: 15-10-2008, 02:00 AM
  4. migrating away from SBS 2003 to windows 2008 and exchange 2007
    By Christopher in forum Small Business Server
    Replies: 1
    Last Post: 01-10-2008, 01:13 AM
  5. Migrating from SBS 2003 to Server 2008 and Exchange 2007
    By Paul in forum Windows Server Help
    Replies: 5
    Last Post: 11-09-2008, 03:00 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Page generated in 1,711,623,540.43705 seconds with 17 queries