More simple compiling questions etc

[john]

Cant seem to find a simple clean overview of access in any books
around the local stores.

First --- is the compiler in all the versions? Im using Access that
came with Office 2003. Is the standalone version more complete?

The developers package -- is that the version with Visual Studio?
Thats the only way you can distribute your ACCESS programs with with
a runtime version of access right?

Access -- its bascally a visual programming environment where you pick
objects and add/choose options a bit of code to an object like a form
unless you do more extensive coding with what? Visual Basic?

 

[Douglas J. Steele]

The compiler is in all versions of Access. (Just so you know, the compiler
simply determines whether there are syntactic errors in the code. It does
not convert the code to an executable, or anything like that)

Access uses VBA (Visual Basic for Applications), which is slightly different
than VB (and quite different than VB.Net). The editor is built into Access.

There is no difference between the version of Access that comes stand-alone
versus the version that comes in Office Professional.

You need to purchase the following in order to create an Access 2003 runtime
application:

- Microsoft Access 2003
- Visual Studio Tools for Office 2003 (which includes the Access 2003
Developer Extensions)

The ADE is the product that gives you the license to deploy the 2003 runtime
components and you have to have Access 2003 installed in order to install
the ADE.

If you're using MSDN, note that while VSTO is available in all subscription
levels of MSDN, the Access Developer Extensions are not included with all
versions. ADE is only available at Universal level.

The stand-alone VSTO box includes both VSTO and the ADE.

See http://msdn.microsoft.com/vstudio/office/officetools.aspx or
http://office.microsoft.com/en-us/assistance/HA011208861033.aspx for more
details