Results 1 to 9 of 9

Thread: Page Feature

  1. #1
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Page Feature

    Hi, I'm still learning Access but I want to make a webpage with a form that will update the Database, now I want it to work for users who don't have Access, is this possible? I have played around a little with it and could only get it to work for the one's that have Access on their computers already.

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Page Feature

    This is certainly possible. You could use a data access page constructed in Access. (Look up help and type in Data Access Page - you will get a number of references.

    There is a comment on one of these that "users who have a Microsoft Office 2000 license can update data over the Internet or an intranet" This may well be a misprint and should perhaps read "Users who do not have... "

    I think all you need to use the page is IE5 or later.

    The place where the page is located is important. It must be accessible to the proposed users and must be able to link to the database. This may cause problems in a corporate environment.

    The permissions for the database and record locking will also need to be thought about. If one user has the database opened exclusively the Data Access Page will not be able to do much.

    I suggest you try to do it using the help files and come back to the forum if you have specific problems.

    In the real world, I would suspect a more robust form of front end would be used. If you wanted to set up Amazon.com you might need to think about alternative solutions, but if you will not have a large number of simultaneous users Data Access Pages may suit you.

    Warning. Not based on exhaustive experiment.[img]/w3timages/icons/laugh.gif[/img][img]/w3timages/icons/laugh.gif[/img][img]/w3timages/icons/laugh.gif[/img]
    David Grugeon
    Brisbane Australia

  3. #3
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Page Feature

    Sorry, but data access pages are Access 2000-specific and require Office 2000.
    Charlotte

  4. #4
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Feature

    So is there another way to accomplish what I want to do? I just want users to be able to report problems in a form and have that information stored automatically in the database. These users won't have Access though. I use Access 2000.

  5. #5
    Star Lounger
    Join Date
    Feb 2001
    Location
    Wirral, Merseyside, Merseyside, England
    Posts
    88
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Feature

    What you want to do is possible. You will need to store the .mdb file on a web server and write a simple front end for the users to update the table.

    The front end however can't be created in Access you'll need to use ASP or Java or something along these lines.

    The version of Access probably wont matter as Access in this instance will only be the data store.

    Regards
    Carolyn

  6. #6
    Lounger
    Join Date
    Jan 2001
    Posts
    39
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Page Feature

    Oh boy am I in trouble then as I don't have any idea what ASP is and very limited knowledge of Java, anyone know where I can go to learn this stuff???

  7. #7
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    352
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Page Feature

    Thanks Charlotte. How odd.

    Sultan - I apologise for misleading you.
    David Grugeon
    Brisbane Australia

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

    Re: Page Feature

    There is a very simple wizard in Front Page 2000 that allows you to view records from an Access database. I haven't played with it much, but I'm fairly certain that you can edit data with it also.

    HTH[img]/w3timages/icons/thinks.gif[/img]

    -MarkJ-

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Page Feature

    In my opinion, data access pages are toys that Microsoft stuck in there to suck developers into its more powerful (and expensive) web-related technology. They work fine on an intranet where everyone has Access, but that's about all they're intended for except getting your feet wet in the web.
    Charlotte

Posting Permissions

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