raylital
asked on
How can I distribute Access 2000 Database?
I have developed an Access Database and user-interface using Access 2000. Now I am a little confused by the liturature I've seen regarding MSDE and Access 2000.
I would like to know if we can still distribute Access Databases using the Package & Deploy Wizards, the way we did with earlier versions of Access. I do have the Access 2000 Developer CD, and the Enterprise Edition of all the MSDN tools (My MSDN subscription expired during the fall of last year), so I believe I would have everything needed, if it exists. I just am having trouble tracking down what I need to do to package and deploy my Access 2000 solutions.
300 Points to the first person who tells me all of the steps I need to take to package and deploy my Access 2000 solutions (not using MSDE).
Thank you,
Ross
I would like to know if we can still distribute Access Databases using the Package & Deploy Wizards, the way we did with earlier versions of Access. I do have the Access 2000 Developer CD, and the Enterprise Edition of all the MSDN tools (My MSDN subscription expired during the fall of last year), so I believe I would have everything needed, if it exists. I just am having trouble tracking down what I need to do to package and deploy my Access 2000 solutions.
300 Points to the first person who tells me all of the steps I need to take to package and deploy my Access 2000 solutions (not using MSDE).
Thank you,
Ross
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Good point Nic;o, don't forget you can test the runtime by Creating a shortcut and and include the /RUNTIME parameter in the command line then this will it on your PC.
"c:\program files\microsoft office\office\msaccess.exe
Tis does not test your references though asnd you do need to test thoroughly.
Cheers, Andrew
"c:\program files\microsoft office\office\msaccess.exe
Tis does not test your references though asnd you do need to test thoroughly.
Cheers, Andrew
ASKER
I'm very encouraged by your answers, but I can't seem to find the "Package And Deployment" Wizard using my Add-Ins Manager. I've browsed all around the subdirectories of "Program Files\Microsoft Office\..." and I can't seem to find any Add-ins at all, in fact. Where do I find the add-in, in order to add it?
Thank you,
Ross
Thank you,
Ross
Have you installed the Office 2000 Developer Tools? If so it should be as I said in my comment of 11/16/2002 12:21AM PST
If you have and it is not there then there is a bug when it doesn't show in the menu but I can't remember what the fix is, I will investigate and get back to you if I can find it.
Cheers, Andrew
If you have and it is not there then there is a bug when it doesn't show in the menu but I can't remember what the fix is, I will investigate and get back to you if I can find it.
Cheers, Andrew
You'll have to activate th eAddIn manager first.
At the bottom you'll be able to select between showing the "Package And Deployment" Wizard just once or everytime you startup Access. There you need to make a choice and the "Package And Deployment" Wizard will be displayed.
Nic;o)
At the bottom you'll be able to select between showing the "Package And Deployment" Wizard just once or everytime you startup Access. There you need to make a choice and the "Package And Deployment" Wizard will be displayed.
Nic;o)
ASKER
Well, I *believe* I installed the tools--that's when I first became confused and thought maybe Microsoft decided to only allow distribution using the MSDE. I'll try a reinstall sometime today, and thank you very much again.
Ross
Ross
ASKER
I'm increasing the points to 360, I really appreciate the help. If I had more points, I'd throw them in the pot.
In fact, I did not have the Developer Tools installed, and as I tried to install them, my memory of the problem became clearer. First of all, the Developer Tools Installation routine complained that "It needs VBA for Applications 6.0, or a product with VBA for Applications 6.0 installed, such as Office 2000."
Well, I did have all of office 2000 installed, so I reinstalled, and the developer tools installation gave me the same error "VBA For Applications" error. So, I installed VBA For Applications (although I don't think it should have been needed). I am still getting the "VBA For Applications 6.0 or Microsoft Office 2000 needs to be installed" error.
I'm on my way out to MSDN now, but if someone posts the correct answer, I'll gladly award you the 360 points, even if I find the answer at MSDN as well.
Thanks again, I'm really pulling my hair out on this.
Ross
In fact, I did not have the Developer Tools installed, and as I tried to install them, my memory of the problem became clearer. First of all, the Developer Tools Installation routine complained that "It needs VBA for Applications 6.0, or a product with VBA for Applications 6.0 installed, such as Office 2000."
Well, I did have all of office 2000 installed, so I reinstalled, and the developer tools installation gave me the same error "VBA For Applications" error. So, I installed VBA For Applications (although I don't think it should have been needed). I am still getting the "VBA For Applications 6.0 or Microsoft Office 2000 needs to be installed" error.
I'm on my way out to MSDN now, but if someone posts the correct answer, I'll gladly award you the 360 points, even if I find the answer at MSDN as well.
Thanks again, I'm really pulling my hair out on this.
Ross
ASKER
Well I found the answer in the MSDN Knowledge Base, Article 322632 (at http://support.microsoft.com)
MOD2000: "Microsoft Office 2000 Developer Requires Visual Basic for Applications 6.0" Error Message When You Install Microsoft Office 2000 Developer.
SYMPTOMS
When you install Microsoft Office 2000 Developer, you receive the following error message:
"Microsoft Office 2000 Developer requires Visual Basic for Applications 6.0. Before installing Microsoft Office 2000 Developer, install Office 2000 or another application that contains Visual Basic for Applications 6.0.
You receive this error message even though Microsoft Visual Basic for Applications 6.0 is installed on the computer.
RESOLUTION
To resolve the issue, locate the ACMBoot.exe file on the root directory of the Microsoft Office 2000 Developer CD, and then run it. You can install Office 2000 Developer successfully when you start Setup in this manner.
--and it worked. I've packaged my database solution, now its time to go and test!
Thanks for all your help, and I hope this helps someone else too!
Ross
MOD2000: "Microsoft Office 2000 Developer Requires Visual Basic for Applications 6.0" Error Message When You Install Microsoft Office 2000 Developer.
SYMPTOMS
When you install Microsoft Office 2000 Developer, you receive the following error message:
"Microsoft Office 2000 Developer requires Visual Basic for Applications 6.0. Before installing Microsoft Office 2000 Developer, install Office 2000 or another application that contains Visual Basic for Applications 6.0.
You receive this error message even though Microsoft Visual Basic for Applications 6.0 is installed on the computer.
RESOLUTION
To resolve the issue, locate the ACMBoot.exe file on the root directory of the Microsoft Office 2000 Developer CD, and then run it. You can install Office 2000 Developer successfully when you start Setup in this manner.
--and it worked. I've packaged my database solution, now its time to go and test!
Thanks for all your help, and I hope this helps someone else too!
Ross
ASKER
Thanks TextReport. You answered the question as posted, and gave me food for thought in saying that you "believe there is a bug...."
I want to be fair, so here are your points.
Ross
I want to be fair, so here are your points.
Ross
I stopped using the runtime version as the right-click sort/filter pop-up isn't supported :-(
But also some other features might work differently...
Nic;o)