Question features of access 2007

[drstein]

When comparing access 2007 to sql server 2008 r2, can you tell me if access has the following features:

1. stored procedure,
2. function,
3. view,
4 script to run that completes several tasks?

If any of the items I listed above are in access 2007, can you tell me what the feature is and how to access that feature?

Also are the features in access 2007 that are probably not in sql server 2008 r2 that I should be aware of? If so what are those features and how do you access those features?
*Note: The only thing extra I know exists are forms and reports.

 

[mdlueck]

Of that list:

1. stored procedure,
2. function,
3. view,
4 script to run that completes several tasks?

I suppose you could think of VBA in Access as comparable to SQL scripts (4). Syntactically they are not equivalent, however.

Access does not have the other capabilities.

For what purpose are you conducting this comparison? A desktop database and a database server product are very different. Perhaps with some background answers would be of more benefit to you.

 

[pbaldy]

1) A stored procedure could generally be replicated in Access by some combination of queries and VBA, depending on its specifics.

2) A VBA function could probably replace many/most functions.

3) A view is basically a query, so I suppose a saved query could be used like a view.

4) To accomplish several tasks you'd need to use VBA (or a macro). A query in Access can't run several tasks like a stored procedure can in SQL Server.

It's somewhat out of date, but I find the "Microsoft Access Developer's Guide to SQL Server" by Chipman and Baron to an excellent resource for working with the two. It doesn't contain the latest features of either Access or SQL Server, but the general concepts are still pretty relevant.

 

[drstein]

Are there stored procedures in access 2007? If so, how do I access the stored procedures in access 2007?

 

[drstein]

I am asking the questions about:
1. stored procedure,
2. function,
3. view,
4 script to run that completes several tasks.

Since I have alot of access 2007 databases that I need to work with and have no expereince with access 2007. I do have expereince with sql server 2008 re2.

 

[pbaldy]

You seem to be simply repeating your questions without acknowledging the answers given, rather than asking a follow-up question. In short, there are no stored procedures in Access. The closest equivalent is VBA.

Perhaps if you gave a specific task, we could tell you how to accomplish it in Access.