Regarding MS Access and Storeed Procedures

[Guest]

Hi all,

Is there any way trhat i can write Dynamic Stored Procedures and Triggers
for MS Access Database through MS Access? The requirement is to use only MS
Access. The front end will be MS Access forms. MS Access forms will call
stored procedure and trigger for data processing in MS Access.

It has been suggested by our client to use only MS Access. Which restrict us
using MS SQL server. I will be thankful, if any one can help me on this
regard.

thanks,
Chakkaradeep

 

[Tom Ellison]

Dear Chakkaradeep:

Well, for one thing, MSDE ships with Access. The ADP interface allows you
to create and edit SPs. An SP could be used to create a trigger. So, I
don't see any problem.

Now, it is certainly true that Jet and MDBs are the vast majority of what is
written with Access. However, in any reasonable sense, MSDE is every bit as
much Access as Jet is, except in the prevalence of usage. But, it's
certainly there! So, I defy anyone to say MSDE isn't Access in the same
sense that Jet is.

An alternative is two write VBA to do whatever it is you want from your SP.

Of course, the interface to MSDE isn't there. By that I mean Enterprise
Manager and Query Analyzer. You could, however, use these superior tools to
get the SP working and tested. Then just copy and paste the code from there
into another copy of the database, using the Access interface to actually do
this. Nobody could ever prove you had done this.

Not sure what you mean "call . . . [the] trigger." That's not the way I
understand a trigger works. It's just there, and does it's job under the
conditions described when it's set up. Probably this is just a problem with
my understanding of your intent.

You may, but are not required to, use an ADP to write this. SQL server
(MSDE) is accessable through MDBs. Whatever seems most comfortable.

Tom Ellison