Visual Studio 2003 with access 2000?

I

ianalexh

We want to use Access for people in our company to enter data w/o purchasing
access itself for everyone, and it appears i need Visual Studio Tools to
accomplish this. our access is 2000; if we purchase VST 2003 do we also need
to upgrade access to 2003? is VST the only way to develop access in this
way, or are there other options as well?

each person will have his own database; it is not central (though it might
be useful to use some tables company-wide)

thanks!
 
D

Douglas J. Steele

Yes, at present, VSTO (Visual Studio Tools for Office 2003) is the only
thing Microsoft markets that will allow you to use an Access application
without having to purchase an Access license for each user.

Access 2003, though, is capable of using the Access 2000 file format (in
fact, it's the default file format for Access 2003), so I believe you would
be able to leave your application in that format, so that others who already
have Access 2000 will continue to be able to work with it.
 
G

George Nicholson

Access files require either the Runtime or Retail version of Access if you
want to use Access forms, reports, etc. VSTO (and its older cousins) come
with a royalty-free license to distribute Access Runtime files with your own
applications. Note that Runtime functionality is reduced when compared to
Retail version. (You can't create or modify objects. Built-in toolbars are
not available: the developer must provide substitutes. etc.)

If you get VSTO (for Office 2003) then you need to get at least one copy of
Access 2003. I'm pretty sure that the Access Developer's Extensions in VSTO
require that Access 2003 be installed before the ADE can be used/installed.
Assuming that this would all be placed on a "developer's machine", you could
then create an Access 2003 runtime package for distribution.

Alternatively, since you are using Office 2000, you might try looking for a
second-hand copy of Office 2000 Developers Edition or Office 2000 Developers
Tools upgrade. (2000 Developers Edition = Office 2000 Professional +
Developers Tools). You would be able to create an Access 2000 runtime
package with that.

Or, alternatively again, find a 2nd hand copy of Office XP/2002 Developers
Edition and create an Access 2002 runtime. (There was no separate Developers
Tools upgrade for Office XP/2002.) You might even be able to find a
retailer who still has a factory shrink wrapped copy.
 
D

Douglas J. Steele

George Nicholson said:
If you get VSTO (for Office 2003) then you need to get at least one copy
of Access 2003. I'm pretty sure that the Access Developer's Extensions in
VSTO require that Access 2003 be installed before the ADE can be
used/installed. Assuming that this would all be placed on a "developer's
machine", you could then create an Access 2003 runtime package for
distribution.
Click to expand...

You're right, George: you cannot install ADE unless Access 2003 has been
installed.
 
6

'69 Camaro

Hi.

The Access Developer Extensions are included in the 10-CD set of the
standalone VSTO package or the VSTO that's included in the Universal MSDN
subscription. The Access Developer Extensions are not included in the other
editions of VSTO, nor in any other product.

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Top