#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 2000
    Location
    Southfield, MI USA
    Posts
    1
    Rep Power
    0
    I have hosted a web site with Access database. I am trying to create
    Maintenance Dataentry forms to add/change/delete records from this hosted
    Access database. These forms are for my use only and not for the site users.

    I am trying to avoid developing long winded ASP programs and found out that
    Access generates ASP files. I have tried in both Access versions.Following are my issues with Access 97 and 2000.

    Access 97:
    Example Student.Asp and Studentalx.asp
    Generates two ASP files from the Export wizard (one with alx suffix).
    Creates Record Add/change/del options
    When I run it (in localhost itself), Student.asp shows a box with no data
    and Studentalx.asp shows a record with nav buttons. But is not fully
    functional.

    Can you tell me the steps I am missing in generating?


    Access 2000

    - Have a new feature to generate "data access page" which generates htm files
    - works fine on the localhost. - when hosted does not able to point to the database on the web server. Under <Object> tag the local database is linked. I changed this to server side as my database is on a web site. When executed this asks for Data Source Logon. This was not required for local access.


    - How do you make this work with web hosted database?

    Any help is appreciated....
  2. #2
  3. SwollenMember
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jun 2000
    Location
    the master control
    Posts
    264
    Rep Power
    15
    I am pretty familiar with ASP, but I did not read your whole question...however I would suggest posting it on www.asp101.com, it has a very good general forum for questions like you have asked.

IMN logo majestic logo threadwatch logo seochat tools logo