how to create stored procedures & triggers in MS Access?

[Manish Bafna]

speaking of me, I'm not very new to Access, but I haven't worked on it
as a professional.
I know that you can fire queries in Access, but I don't think you can
create views.
i want to know that is there any way to create stored procedures or
triggers in Access.
Also, I want to know that can we migrate data from any platform?
i downloaded this rdbms s/w from
http://www.vaman.net/vmndataserver.asp
i tried this s/w. this solved my most of problems (in context with
user friendliness of Access)
these people claim that they have a data migration tool which can
migrate data from any db to vaman & vice versa.
I tried this data migration tool, its working just fine.

i wud like others as well to atleast have a look at this particular
software, b'coz this is really good.

[Douglas J. Steele]

Access doesn't have triggers or stored procedures. On the other hand, a
SELECT query in Access is the same thing as a view.

Access is somewhat limited in terms of what it can import: essentially just
text, Excel, Lotus 123, Paradox, dBase and FoxPro. If the DBMS to which
you're referring can export to one of those formats, you should be okay.
Even better would be if there are ODBC (or OleDB) drivers for that DBMS:
then you can import or link.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
"Manish Bafna" <ma***********@yahoo.com> wrote in message
news:2b**************************@posting.google.c om...

speaking of me, I'm not very new to Access, but I haven't worked on it
as a professional.
I know that you can fire queries in Access, but I don't think you can
create views.
i want to know that is there any way to create stored procedures or
triggers in Access.
Also, I want to know that can we migrate data from any platform?
i downloaded this rdbms s/w from
http://www.vaman.net/vmndataserver.asp
i tried this s/w. this solved my most of problems (in context with
user friendliness of Access)
these people claim that they have a data migration tool which can
migrate data from any db to vaman & vice versa.
I tried this data migration tool, its working just fine.

i wud like others as well to atleast have a look at this particular
software, b'coz this is really good.