Results 1 to 5 of 5
  1. #1
    Join Date
    Sep 2003
    Posts
    10

    Unanswered: is it possible 2 create views, triggers & stored procedures in Access?

    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.

  2. #2
    Join Date
    Feb 2003
    Location
    @ home
    Posts
    163

    Re: is it possible 2 create views, triggers & stored procedures in Access?

    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

    Originally posted by manishbafna80
    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.

  3. #3
    Join Date
    Sep 2003
    Posts
    4
    yes for sure it is.

  4. #4
    Join Date
    Apr 2002
    Location
    Germany
    Posts
    32
    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

  5. #5
    Join Date
    Nov 2003
    Posts
    3
    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,

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •