Results 1 to 7 of 7
  1. #1
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking Unanswered: Coding ASP to use Access data

    Hi everyone,

    I am interested in knowing just what is needed to use ASP 3.0 to make working with data in Access 2000 accessible from an already created webpage? Mainly the database will be for certain key persons to most ADD data to the database, i.e. when they come upon a new customer and don't want to wait until they get back to the office, or not wanting to email. Is it hard to do being a Non-ASP user? I have created databases and worked a small bit with SQL and VBA, but not a guru yet. So point me in the right direction and give any simple tips you have. There will be NO tranactions other than just Editing the database to view and add/delete customer info.

    thanks and have a nice one,
    BUD

  2. #2
    Join Date
    May 2005
    Posts
    17
    Have you looked around at hotscripts ? Section ASP > databases ?
    No need to re-invent the wheel when you can find it ready made ;o)

  3. #3
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004

    Talking

    Quote Originally Posted by lynn22
    Have you looked around at hotscripts ? Section ASP > databases ?
    No need to re-invent the wheel when you can find it ready made ;o)
    Hi Lynn22 and thanks for the response. But where do I find "hotscripts"? Never heard of that at all. Believe me, I don't want to re-invent anything, that would save so much time. Does this Hotscripts automatically do the job for me? Again, let me know where to find this hotscripts and I will look into it.

    thanks and have a nice one,
    BUD

  4. #4
    Join Date
    May 2005
    Posts
    17
    Sorry Bud, not quite sure if posting URLs is accepted here.

    hotscripts.com is a site for applications in all types of scripting languages, I'm sure you will find a ready-made script there that will suit your needs.

    Good luck

  5. #5
    Join Date
    Dec 2003
    Location
    Dallas, TX
    Posts
    1,004
    Quote Originally Posted by lynn22
    Sorry Bud, not quite sure if posting URLs is accepted here.

    hotscripts.com is a site for applications in all types of scripting languages, I'm sure you will find a ready-made script there that will suit your needs.

    Good luck
    Hi Lynn,

    Thank you much and I will go check that site out. Oh, it is ok to post URL's here.

    BUD

  6. #6
    Join Date
    Oct 2005
    Posts
    178
    Quote Originally Posted by Bud
    Hi everyone,

    I am interested in knowing just what is needed to use ASP 3.0 to make working with data in Access 2000 accessible from an already created webpage? Mainly the database will be for certain key persons to most ADD data to the database, i.e. when they come upon a new customer and don't want to wait until they get back to the office, or not wanting to email. Is it hard to do being a Non-ASP user? I have created databases and worked a small bit with SQL and VBA, but not a guru yet. So point me in the right direction and give any simple tips you have. There will be NO tranactions other than just Editing the database to view and add/delete customer info.

    thanks and have a nice one,
    BUD
    Following you need to know how to communicate with your data in the server.
    ASP.net is different on the syntax, but the idea is the same.

    Creating DSN in IIS server

    On your web server ( computer with IIS service installed). For example in XP OS, Goto control panel – Performance Maintenance- Administrative Tools – Click Data Source (ODBC)



    Select System DSN tab if data is to be shared in the network. Click “Add”


    Select appropriate driver for appropriate database. In this example selecting for
    MSAccess database



    Name the DSN and remember this name and spelling for you’re going to use it exactly
    in your codes. Click the “Select” button to get to your backend database.



    Locate your backend database.


    After pointing to your backend database and Oked. Your back in ODBC tab with the database path showing. Before you click OK to exit, remember the Data source Name or
    Write it down for correct spelling.



    Use the vbscript below to connect to your Data Source Name “DataName”
    Code:
    <%
    Const adOpenStatic = 3
    Const adLockOptimistic = 3
    Const adCmdText = 1
    Dim ThisName 
    
    Set RS = Server.CreateObject(“ADODB.Recordset”)
    RS.Open “Select fieldname1 From tblname”, “DSN=DataName”,adOpenStatic, adLockOptimistic, adCmdText
    
    ThisName = RS(“fieldname1”)
    
    RS.close
    Set RS = nothing
    
    %>
    Below attachement is the graphical intruction.
    Attached Files Attached Files
    Last edited by fredservillon; 11-30-05 at 11:14.

  7. #7
    Join Date
    Jun 2003
    Location
    USA
    Posts
    1,032
    And perhaps this may hopefully give you some ideas:

    Web Database Concept
    http://www.bullschmidt.com/concept.asp

    And www.asp101.com/samples has some good, short database examples.
    J. Paul Schmidt, Freelance Web and Database Developer
    www.Bullschmidt.com
    Access Database Sample, Web Database Sample, ASP Design Tips

Posting Permissions

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