Page 1 of 2 12 LastLast
Results 1 to 10 of 16

Thread: Another off topic... Help me SQL, Access 97, Web

  1. #1
    Variable Bitrate
    Join Date
    Aug 2000
    Location
    Pgh, PA
    Posts
    224

    Exclamation Another off topic... Help me SQL, Access 97, Web

    I have designed a very useful database at work using Access 97. What is the best way to get it online? It uses Tables, Forms, queries, Reports and macros. PLEASE HELP ME
    -+[MP3PC]+-

  2. #2
    Low Bitrate
    Join Date
    Aug 2001
    Posts
    107

    Post

    Does your web server use Windows, or the better choice of Linux?

    If it's Linux, just make it with MySQL on the box..

    Scott--
    -=~=-=~=-=~=-=~=-=~=-=~=-=~=-=~=-=~=-=~=-=~=-
    97 Firebird Formula Convertable - Project R/T
    Project R/T SoundDomain Page
    -=~=-=~=-=~=-=~=-=~=-=~=-=~=-=~=-=~=-=~=-=~=-

  3. #3
    Maximum Bitrate
    Join Date
    Nov 1999
    Location
    Sydney NSW Australia
    Posts
    581

    Post

    I believe that Access 2000 has inbuilt option of creating web pages incorporated with Access database. I think Access 97 has it too.
    The easiest way to link this with web is to run IIS server and link Access with it.
    IIS comes with Win NT and Win 2000.
    There is another one for Win9x but i dont think it will work with Access.
    Fosgate

    System Comp V3 - In progress.
    Low power MB with C7 CPU, DC-DC PSU, car ECU link, USB TV, GPS, 7" TFT, Wireless, Voice.

  4. #4
    FLAC
    Join Date
    Apr 2001
    Location
    Here, There, Everywhere
    Posts
    1,436

    Post

    if you want the functionality of the access database, which I think you do since you mentioned forms/reports/macros then you best bet is to look into what Fosgate is talking about. From memory I think Access has a "web portal" add-in, letting you use access from a web browser via an IP address.

    If only the tables and data is really required, maybe look at building a website using a scripting language such as .asp or .php with the database. ASP supports access databases directly and runs under IIS with win NT/2000 and Personal Web Server (PWS) under Windows 98....

    if it can be done, the first solution will be the most painless and quickest.....
    Project - GAME OVER :(

  5. #5
    Variable Bitrate
    Join Date
    Aug 2000
    Location
    Pgh, PA
    Posts
    224

    Post

    It is window NT soon to be 2000. It is running IIS. I do not have direct contact with the IIS server but I pass on my needs for them to be completted. I did notice that access has an export feature but I was lost using it. Not sure what to point things to and what format to use. I also don't know what info the IIS manager needs to modify on his box. Any help or a URL would be great.... Having the macros, reports, and forms is important.
    -+[MP3PC]+-

  6. #6
    Variable Bitrate
    Join Date
    Nov 1999
    Location
    Ishoej, Denmark
    Posts
    310

    Post

    Just one minor detail, beware that Access doesnt scale well. If you dont expect a lot of trafic on your site it wont be a problem, but if you expect more than a few simutaneously (i just cant spell that word..)
    you may run into problems because Access locks entire tables when processing data from it, MSDE/MSSQL server only locks the record in concern...

    Appart from this detail i believe the others have supplied you with the information required..

    Good luck

  7. #7
    Maximum Bitrate Raas's Avatar
    Join Date
    Jan 2001
    Location
    The Netherlands
    Posts
    626

    Post

    Doesn't the access-export feature add a lot of junk in the html/asp pages.. like frontpage was doing...
    This would also slow the pages down..

    If you have any skills with access and you know how to write VB(A),
    Then the easiest thing to do is build a site from scratch..

    You can connect to the database in 2 different ways.. use odbc or not...

    When I got first into this i went to brinkster
    Because I didn't have a server then.
    You get 30megs ASP enabled website, and there are lots of tips and articles for beginners..

    Hope this helps you out..

    PS.. I remind something that you could run ASP-pages on a linux or unix server using... Cake for linux ???!?!?!??!?! (don't know the exact name anymore)

    Greetz
    Raas - The Netherlands
    ME: VIA epia m10000, lilliput 7', opus 150w, 80gb<br>
    GF: IBM Thinkpad 380, ext. 3.5 80gb, 40x4, PB-IR

  8. #8
    Maximum Bitrate Meatballman's Avatar
    Join Date
    Jul 1999
    Location
    Hartsville, SC
    Posts
    747

    Post

    Some pertinent information:

    Access has a built-in limitation of 256 connections.

    You mention forms and reports: you will need to create a new front end application to duplicate these in your favorite web scripting language (ASP, PHP, PERL, etc..)

    Here is a pretty decent page to get you started on your way. It has a step-by-step to help you set up your ODBC conection and use Access's built in web export stuff.

    [ 08-21-2001: Message edited by: Meatballman ]

  9. #9
    Maximum Bitrate Meatballman's Avatar
    Join Date
    Jul 1999
    Location
    Hartsville, SC
    Posts
    747

    Post

    Originally posted by Raas:
    <STRONG>
    PS.. I remind something that you could run ASP-pages on a linux or unix server using... Cake for linux ???!?!?!??!?! (don't know the exact name anymore)
    </STRONG>
    Are you referring to ChiliASP? Or is there a free alternative?

  10. #10
    Variable Bitrate
    Join Date
    Aug 2000
    Location
    Pgh, PA
    Posts
    224

    Post

    We have 700 plus users but it is Very unlikely that we have more than 10 users in it at a time MAX. Perhaps there is a way to just launch access 97 from a link in a website. EVERYONE has access installed and it is an Intranet website. I am really hoping to be able to use my current macros, forms, and reports.
    -+[MP3PC]+-

Page 1 of 2 12 LastLast

Bookmarks

Posting Permissions

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