Results 1 to 3 of 3
  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
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    never tried views, but i just happen to be reading my bible at the right page in the build-up to a move to mysql

    my bible tells me you can create views in access!

    new query (no tables), then menu:Query¦SQL Specific¦Passthru, then:
    CREATE VIEW blah AS SELECT this, that FROM theOther;
    run it, select the data source (probably login stuff too).

    my bible tells me not to worry about a potential error msg during this create process saying "pasthru is not returning any records".

    then you can link to the view (you will get a prompt for uniqueID) from A

    interested to know if this works - i might need it myself.

    izy

  3. #3
    Join Date
    Dec 2002
    Location
    Préverenges, Switzerland
    Posts
    3,740
    hmmm, the next few pages show how to make & run stored procedures.
    Alison Balter: Mastering Access XXXX Development (mine is A95, but 2000 exists)

    izy

Posting Permissions

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