By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,460 Members | 2,215 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,460 IT Pros & Developers. It's quick & easy.

how to create stored procedures & triggers in MS Access?

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.