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.

You can creste something similar to views and stored procedures, but i don't know how to create something to work like a trigger.

If all that was possible access could grow up to become a real and reliable database.

Paulo

yes for sure it is.

MS Access (or better the jet engine) doesn't really support views. It uses so-called stored queries. You can use ADO to write a CREATE VIEW statement. But its the same.
For stored procs and triggers you use VBA scripts. The trigger depends on an Access event.

Of course, it is not the same like a real SQL procedure or trigger. If you want to use real SQL statements with Access you have to create an Access Data Project (ADP). ADP uses the MSDE (SQL Server).

peter

Hey, manish you are right. I just went to the Vaman site and checked it out. Site's Ok, but the DataServer is kickass. I have never seen anything like it before. The data migration looked a little difficult in the beginning, but I managed.

These guys have something really up their sleeve. I would like to find out how they do this. Nice to see that M$ has some decent competition

Cheers,