Results 1 to 7 of 7
  1. #1
    JeffGeorge is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    111

    Converting Module To Newer Version

    I have an old database that was created in Access 2000. The VB has 2 categories: Modules and Microsoft Access Class Objects. There are 4 objects in the Microsoft Access Class Objects. I want to try to use them in an Access 2010 version of the database. In Access 2010 Microsoft Access Class Objects appear in 2 new places: ACWZMAIN and ACWZTOOL. Where would I put the code from these old objects in the new database?

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Have you tried opening the file in Access 2010?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    JeffGeorge is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    111
    I have and I've tried to update it but I get an error message of "the Microsoft Access database engine cannot find the input table or query 'MSysAccessObjects'. Make sure it exists and that its name is spelled correctly." I figured it would just be easier to reproduce the database in the newer software.

  4. #4
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Are you trying to convert a VB6 project to an Access database?

    If it is actually an Access 2000 db file you want to upgrade, can you import objects? That would be the next simplest approach.

    I don't know why those class objects are listed but you can't modify them. Review http://support.microsoft.com/kb/208307
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  5. #5
    JeffGeorge is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    111
    The VB already exists in the Access 2000 database.

    The first image shows the modules, listed under Microsoft Access Class Objects, that I want to bring into the Access 2010 database. I can export them with no trouble.

    Click image for larger version. 

Name:	ArchiveDB1.PNG 
Views:	15 
Size:	48.2 KB 
ID:	19508

    However, when I try to import it into Access 2010 I get the error shown in the 2nd image. The only part of the error that seems applicable is the name length. If I shorten the name will it have any adverse effects on the other parts of the database that I've reproduced in Access 2010?

    Click image for larger version. 

Name:	ArchiveDB2.PNG 
Views:	15 
Size:	37.3 KB 
ID:	19509

  6. #6
    June7's Avatar
    June7 is online now VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,825
    Since those modules are the code modules for the forms, the Form_ prefix is valid. Spaces in names should be avoided but Access should be able to handle them in this case. The name lengths are not too long.

    I don't know why Access 2010 is having these issues with this file. If you can't open the 2000 file, how could you change the names?

    If you want to provide the old db for analysis, maybe can attach here - follow instructions at bottom of my post.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    JeffGeorge is offline Competent Performer
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2013
    Posts
    111
    I'm currently testing another approach. I am exporting each of the Access 2000 objects to a new database. If that still gives issues I will post the original database.

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

Similar Threads

  1. Replies: 1
    Last Post: 08-15-2013, 08:12 PM
  2. Importing Access 2000 files to newer version
    By jrmbach in forum Import/Export Data
    Replies: 1
    Last Post: 08-04-2013, 03:49 PM
  3. Replies: 4
    Last Post: 03-13-2013, 08:57 PM
  4. Replies: 1
    Last Post: 01-30-2013, 07:32 PM
  5. Converting Excel Macro into Access Module
    By diddyville in forum Modules
    Replies: 1
    Last Post: 03-28-2011, 07:02 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
  •  
Other Forums: Microsoft Office Forums