How can I distribute Access 2000 Database?

raylital
raylital used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Install the Office 2000 Developer Tools then go into your database and design a module. The select Add-Ins Menu and the package and deployment wizard should be listed there select it and follow the prompts not forgetting to include the runtime option.

You may need to use the Add-Ins Manager to start the add-in.

Cheers, Andrew

Commented:
Hmm, just a warning when using a runtime version, first TEST your application AGAIN in the runtime environment.

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)
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" /RUNTIME "c:\mydatabase.mdb"

Tis does not test your references though asnd you do need to test thoroughly.

Cheers, Andrew
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
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
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

Commented:
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)

Author

Commented:
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

Author

Commented:
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

Author

Commented:
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

Author

Commented:
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

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial