Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
  #1 (permalink)  
Old February 2nd, 2005, 11:01 PM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default Tools Needed!

Hi all,

I'm developing an application in Access 2003. I'd like to know all the tools necessary to create a stand-alone version once completed. I've heard different things and was hoping someone in this forum would know. Before I start spending money, I want to make sure I'm getting the correct stuff.

Thanks in advance,

Kevin

__________________
dartcoach
  #2 (permalink)  
Old February 4th, 2005, 02:49 AM
Authorized User
 
Join Date: Jan 2005
Location: , VIC, Australia.
Posts: 14
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hey,

I am not too sure about Access 2003, but with Access 2000 you can get an additional disk containing Office Developer tools and on that I'm sure that there's something on there called "Package and Deployment", or something like that.

What that will allow you to do is to package your application and include mdb's, icons, dll's or any other files you have used with it and create a setup installation.

You then run the setup.exe on any machine and it will install it.

However, during the installation it will install the runtime version of Access, which can be distributed freely anyway. There is no way, as such, to create a "standalone" application with Access.

Cheers

Rohan
  #3 (permalink)  
Old February 4th, 2005, 06:02 AM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

That's exactly what I'm looking for! The problem is, that the "package and deployment" piece, which Office Developer tools is it with? I've had different people give me different software titles and I'm attempting to narrow it down.

Thanks,
Kevin

  #4 (permalink)  
Old February 4th, 2005, 07:40 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Hi Rohan,

Here's a link to something I posted a while back about the developer tools:

http://p2p.wrox.com/topic.asp?TOPIC_ID=16590

The relevant portion in your case is:

Quote:
quote:The Access developer tools change their name pretty much with each new version of Access:

A2K - Microsoft Office 2000 Developer Edition (ODE)
A2k2 - Microsoft Office Developer (MOD) 2002
A2K3 - Access 2003 Developer Extensions (part of the new Visual Studio Tools for the Microsoft Office System software package).
HTH,

Bob

  #5 (permalink)  
Old February 4th, 2005, 01:19 PM
Friend of Wrox
 
Join Date: Mar 2004
Location: Yorba Linda, California, USA.
Posts: 217
Thanks: 0
Thanked 1 Time in 1 Post
Default

Kevin,
As Bob said, "Package and Deploy" and "Runtime" are in ODE for 2K.

While P & D does put together an install package, we had some problems with the package installation. After we "tinkered", we found it was not necessary for our project. (Ours only requires one .dll and an icon with the .mdb).

We installed "Runtime" on our users systems without Access and now double click on an .MDB (any .mdb) to launch it. (Of course, they are end users and will not be making structural changes to the DB, and have absolutely no reason to be directly into tables, etc.)
We found when we installed "Runtime" there was no message box that appeared to say it was successfully installed, and really install did not complete until we opened an .mdb. The process of opening the .mdb causes it to take off more files from "Runtime"- if you do not have the Runtime install disk you will get runtime error 1706. (We saw alot of #1706 before one of the Techs figured that out). Also, we found "Access" did not come up under "Programs" in the start menu, so we thought is was not installed.

We also found Runtime does not always peacefully co-exist with a full version of Access. We put Runtime on a new machine that was being set up to test the installation, and left it on because it was not interferring with full Access. Full Access worked fine for several weeks, then would not open and reported Runtime causing an error (I don't remember the message or code). Once we took Runtime off it has been fine.

Another thing, Which I'm sure YOU WON'T do, but I'll mention it because I DID it..... I did not put error handlers in all events. So when an error occurred, Access reported "An error occurred and Access has to close". Oops!

One other thing to look out for. I bought a single disk called "Office 2000 Developer Tools" thinking that was what I needed. IT DID NOT contain anything useful to me (If I remember, it had server extensions and something for e-mail). As Bob suggested, I was able to purchase ODE 2K from Ebay and I think I spent about $300, or $310. It took about 6 weeks to find, but when it came up there were 3 packages from different vendors that appeared at the same time. It was an unopened package and came with full Office Premium, (of course), "Developer", "MSDN Library for Office2k Developer" and some handy manuals.

Bob, I haven't had an opportunity to try Runtime A2K with an A2003 mdb. My husband is putting together another system, so if I can get to it before Access goes on, I'll give runtime a try. And thank you, Bob, for your help. I always enjoy reading your replies and your insight into Access and VBA and am learning alot.

Loralee


  #6 (permalink)  
Old February 4th, 2005, 01:20 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Oh, and "the package and deployment piece" (aka, the Package and Deployment WIzard) is included in all versions of the developer tools.

Bob

  #7 (permalink)  
Old February 4th, 2005, 01:40 PM
Friend of Wrox
 
Join Date: Jan 2005
Location: Kansas City, Missouri, USA.
Posts: 471
Thanks: 0
Thanked 1 Time in 1 Post
Default

Thanks all!! I'll start looking for the tools. I've found some places for Visual Studio Tools for the Office system.

Thanks again for all your help!!

Kevin



  #8 (permalink)  
Old February 6th, 2005, 12:46 AM
Friend of Wrox
 
Join Date: Jun 2003
Location: , , USA.
Posts: 1,093
Thanks: 1
Thanked 12 Times in 11 Posts
Default

Thanks for the kind words Loralee :) You're welcome. Good to hear from you.

Bob



Similar Threads
Thread Thread Starter Forum Replies Last Post
tools.jar reza_ahmadi Java Espanol 0 December 26th, 2006 07:11 AM
Third Party Tools surendran MySQL 1 March 18th, 2005 11:30 AM
Reporting Tools Jane SQL Server 2000 1 December 20th, 2004 04:05 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.