Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Location
    East Coast(USA)
    Posts
    109
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Survey Database (Access 2000)

    I have access database that I'm ready to deploy. It is anonymous "Diversity Survey" database. Using our intranet we were thinking to send the employees e-mail with a link/short cut when they click, will take them directly to the survey database anonymously. How can this be accomplished?

    Thanks,
    DKD

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Survey Database (Access 2000)

    This depends on several factors:

    1) All users must have the appropriate version of Access installed (2000 or above in your case)
    2) The database must reside in a network folder that is shared
    3) All users must have the appropriate network permissions to that folder/file

    If the database is secured (using an MDW file), things will be a little more complicated because your shortcut will have to include the path and filename of the MSACCESS.EXE file relative to each users' computer. This could possibly work, but anyone who has Access installed to a different location will not be able to use your shortcut.

    With these factors understood, you can make a shortcut to the network location (using the named path or a drive letter, assuming all users have the same drive available):

    ComputerNameFolderNameDatabaseName.mdb

    OR

    NatabaseName.mdb

    Consult your network administrator for information regarding the network permissions and sharing.

  3. #3
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts

    Re: Survey Database (Access 2000)

    If you know how to use ASP then users could complete the survey with a web browser, and bypass all those issues.
    Regards
    John



  4. #4
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,594
    Thanks
    0
    Thanked 27 Times in 27 Posts

    Re: Survey Database (Access 2000)

    You could also drive this from an Access Data Page.
    HTH
    Pat <img src=/S/cheers.gif border=0 alt=cheers width=30 height=16>

  5. #5
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Indianapolis, Indiana, USA
    Posts
    1,862
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Survey Database (Access 2000)

    I would agree 100%! ASP is actually a MUCH better alternative.

    Of course, you have to have someone who knows how to write ASP and a web server to run the application on. Also, ASP is much more time consuming to develop (probably 500% more time than a similar Access form).

    Just my 2 cents <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>

Posting Permissions

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