Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Share database (97 / 2002)

    (This post was cut by HansV from a thread in the Word forum since it is clearly an Access question. Subject changed because this is now an independent thread.)
    <hr>Have you thought about sharing your Access form on the intranet. The users would be able to get a print out to fill in by hand or complete it online. This saves on maintenance as well.<hr>
    I have come across a rather annoying problem, in that where I work I have developed (with much help from guys here --- <img src=/S/bow.gif border=0 alt=bow width=15 height=15> ---Thanks) and now it is being implemented.
    While I do any updating, it is useful for other people to view it, new record numbers. Unfortunatley there are different versions of Access (97 and 2002) across the offices.

    I thought I would make a 2002 mde file and a 97 mde file and give each user who requires them their own desktop file, linking to the main table.

    BUT

    Would making a web page form be better? I have never tried to make any web page forms yet.

    enquiringly,
    Thanks,

    pmatz

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Share database (97 / 2002)

    Although performance will not be stellar, you can give Access 97 and Access 2002 users their own frontend to an Access 97 backend database. The backend MUST be Access 97, because Access 97 users can't read Access 2000/2002 tables.

    When we were moving from Office 97 to Office XP where I work, we had to use this solution for a few months, and we didn't experience serious problems.

  3. #3
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Share database (97 / 2002)

    Hans is right, in sticking with an all Access solution. However, if you do not have a lot of 'forms' in the first place, and have the time to create ASP pages, a web Front End is going to be Access independent, so it won't matter what version your office moves to (current version or not), your FE would only be browser dependent.

    ASP development can be pretty fast for viewing information, but data entry can take a bit longer....

  4. #4
    4 Star Lounger
    Join Date
    Aug 2003
    Location
    Stroud, United Kingdom
    Posts
    548
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Share database (97 / 2002)

    Thanks Drew, I am interested in this. The front end is mainly view only. The only datainput comes when people need a new record, which has minimal fields.

    Where can I learn more about making ASP pages? Is there a way to convert Access froms / web pages to these?

    It would be much better if people could just use their browser to view records. Is there a web page with some examples you would recommend?

    Cheers

    <<just answered a lot of my own questions by clicking your link OOPS!! thanks>>
    Thanks,

    pmatz

  5. #5
    4 Star Lounger
    Join Date
    Aug 2002
    Location
    Dallas, Texas, USA
    Posts
    594
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Share database (97 / 2002)

    Getting into ASP is fun, but qutie frankly, I am a trial and error type of guy, so I learned everything from just expiramenting!

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Share database (97 / 2002)

    If your ISP (or your IIS Server if you host your own web page) supports the ASP.net extensions, you might want to look at the Web Matrix Project - see http://www.asp.net/WebMatrix. It's a tool that does lots of the underlying work for you, and doesn't require that you be an expert to start. It also has lots of documentation and help files available. Much of our website was built using it.
    Wendell

Posting Permissions

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