Access and Stored Procedures

[Guest]

Is someone able to confirm the version that access supported stored
procedures... I believe it is Access 2000 Enterprise Edition. Is this
different to Access 2000 Professional Edition or Access 2000 Premium Edition?
I find all these different versions quite confusing.

 

[Duane Hookom]

All versions of Access since 2000 have had the ability to create ADP (Access
Data Projects) that link in directly with SQL Server. You see and manipulate
the SQL objects (tables, stored procedures, views...) in the database
window.

 

[Guest]

looks like I may be confused I was under the assumption that access 2000 (and
2002) enterprise edition contained it's own stored
procedures/views/triggers.... have I been a little silly?

 

[Craig Alexander Morrison]

Not silly, it can be confusing. There is only one edition of Access although
you can get the Developer Extensions (ADE) and the Runtime Licence in the
Visual Tools pack or as part of MSDN Universal, I believe MSDN Enterprise
contains the ADE but not the runtime licence. There are various editions of
Office, Professional and above contain Access.

The Access Data Project makes it look like you are using Access when you are
actually designing objects in the SQLS2000 backend.

The concept behind the ADP was to integrate the SQLS2000 tables in much the
same way as you do with Jet by being able to design Tables, Views, Stored
Procedures and Functions.

A great idea not yet fully realised, and on hold as we speak.

 

[Brendan Reynolds]

Perhaps you may be thinking of the CREATE PROCEDURE statement in Jet SQL?
Despite its name, as far as I can tell this creates an ordinary Jet query,
not a stored procedure in the SQL Server sense of the word (i.e. it is
executed on the client, and not on a server.)

BTW: the editions you mentioned in your original post are editions of
Office, not of Access - there are multiple editions of each version of
Office, but there is only one edition of each version of Access.

 

[Albert D.Kallal]

looks like I may be confused I was under the assumption that access 2000
(and
2002) enterprise edition contained it's own stored
procedures/views/triggers.... have I been a little silly?

As others mentioned, there is one version of ms-access. There is certainly
MANY editions of office (professional, premium etc). However, those premium,
professional and even standard editions of office all have the SAME version
of Excel (there is not a premium edition of excel, or a pro edition of excel
etc.).

So, the only confusing might be what version of office includes access, but
after that, they are ALL the same.

contained it's own stored
procedures/views/triggers

You are not clear by the above at all. What you mean by "its own"? If you
are asking right out of the box using the office cd that includes ms-access,
can you use stored procedures, and views and triggers? The answer is yes.
Since access 2000, the office cd has included two database engines. One
engine is JET, and the other engine is the desktop edition of sql server.
Both of these engines work fine with ms-access. So, if you MUST have stored
procedures and triggers, then choose the 2nd engine (the so called MSDE
engine, which is 100% compatible with sql-server). If you can live without
stored procedures and triggers (and, presumabley use the forms before update
events, or after update events in place of triggers), then you can use the
JET engine. The choice is yours here.