Results 1 to 8 of 8
  1. #1
    Randy is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Jun 2010
    Posts
    48

    Access 2010 Package Wizard


    I have an MDB database (FE, BE) created in Access XP (2002). I now have access 2010 and am using the access 2010 packaging wizard to create an install for my users. The previous vesion of the packaging wizard (XP) had a scan feature that would identify all of the referanced files and allow you to send them with the install package. 2010 does not have this feature.

    When I install the program it works fine except for creating the barcode that is handled by a dll (barcodewiz.dll). I have manually registered it but that doesn't solve the problem. I'm missing something here and I have searched extensively to find a solution without success.

    Any idead... thanks in advance.

    Randy

  2. #2
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    what is happening exactly. I read this and all I read was "it doesnt work".

  3. #3
    Randy is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Jun 2010
    Posts
    48
    The BarCodeWiz.DLL file is not working properly and I think it is because 2010 packaging wizard is not creating the referance during the install. Everything is working with the program except when I print the shipping label it does not have the barcode printed on the label.

    How do I know what files to include with the install program besides the database files that that I have created.

    Hope this is a little clearer.

  4. #4
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    if you're not sure that the reference is being created, try deploying an accdb, mdb or other non-executable to yourself and checking the reference list in the vb editor.

    if you can't do that, or if the packager won't allow that to happen, write some code behind an AUTOEXEC macro or something like that to give you a reference list from the vba editor.

    here's some code to do just that: http://www.google.com/#hl=en&sugexp=...8c32f4f53&bs=1

    check the 2nd one. Chip Pearson at cpearson.com is extremely knowledgable. His site is one of the best, IMO.

  5. #5
    Randy is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Jun 2010
    Posts
    48
    Thanks for your help. I will try that and let you know how it worked out.

    Randy

  6. #6
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    okie dokie.

  7. #7
    Randy is offline Advanced Beginner
    Windows XP Access 2002
    Join Date
    Jun 2010
    Posts
    48
    Okay... it works. The code example you pointed me to, gave me another idea. On my development computer with the program open I pressed 'Ctrl G' to open the code window. With the code window open I selected 'Referances' from the 'Tools' window. I copied all of the paths and file names down.

    I then opened the Package Solution Wizard and began building the install program. When I got to the page in the wizard where you can add additional files I typed in all of the paths to the referanced files.

    When I installed the program on a computer that does not have MS Access 2010 on it, the program executed perfectly.

    I really appreceiate your help. I will mark this one solved.

    Randy

  8. #8
    ajetrumpet is offline VIP
    Windows Vista Access 2007
    Join Date
    Mar 2010
    Location
    N/A
    Posts
    2,694
    Great! Yeeeehawww!

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

Similar Threads

  1. Replies: 1
    Last Post: 04-26-2011, 04:19 PM
  2. Error when using Package Solution Wizard
    By jimrockford in forum Access
    Replies: 2
    Last Post: 04-16-2011, 10:18 PM
  3. package access dtabase in .msi
    By ManvinderKaur in forum Access
    Replies: 1
    Last Post: 08-12-2010, 09:53 PM
  4. Macro for Email Wizard Using the Access Runtime?
    By MFriend in forum Programming
    Replies: 1
    Last Post: 07-12-2010, 04:52 AM
  5. How wizard in access been made
    By miziri in forum Programming
    Replies: 1
    Last Post: 08-20-2009, 03:14 AM

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