+ Reply to Thread
Results 1 to 7 of 7

HTML and Access

  1. #1
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    HTML and Access

    Hi
    I am fairly new to HTML but I have been trying to add data to an Access database

    Sorry website wont allow me to post code so had to use images

    Code for html document
    HTML.JPG

    Code for ASP
    ASP code.JPG

    My Database is called guestbook.mdb
    one table = tblComments
    Database.JPG

    When I submit the html it doesn't update the database and I get this in my web browser
    ASP.JPG

    Any ideas where I a going wrong?
    Regards
    Sean

    Please add to my reputation if you think i helped
    (click on the star below the post)
    Mark threads as "Solved" if you have your answer
    (Thread Tools->Mark thread as Solved)
    Use code tags when posting your VBA code:
    [code] Your code here [code]
    Please supply a workbook containing example Data:
    It makes its easier to answer your problem & saves time!

  2. #2
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: HTML and Access

    Any html code writers out there?

  3. #3
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: HTML and Access

    Sean

    How exactly are you trying to add to the database and where is the database located?

    Where does HTML come into it?
    If posting code please use code tags, see here.

  4. #4
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: HTML and Access

    To run asp code you need a web server, you aren’t running the asp in a web server, you’re just accessing the html file from your hard disk - you can’t do that.

  5. #5
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: HTML and Access

    Hi Norie & Kyle
    The data base is stored on my computer.

    I read somewhere that you can use a web form to communicate with the data base as long as the data base is on the same computer or on a shared drive.
    Is that not the case?
    I was looking at having a web page on our company intranet and users would then be able to update the database on the shared drive.
    Is this not possible?

  6. #6
    Forum Guru Kyle123's Avatar
    Join Date
    03-10-2010
    Location
    Leeds
    MS-Off Ver
    365 Win 11
    Posts
    7,238

    Re: HTML and Access

    It is, but you need a web server to execute the asp code you’ve written. It can’t just be run in the way you’re doing it.

    It might be worth speaking to your it team, if you’ve got an intranet, you’ll have a web server

  7. #7
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: HTML and Access

    Thanks for the heads up.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. VBA to Import HTML Table Locally Stored HTML file to excel
    By ermengard in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-09-2015, 10:48 AM
  2. Access form works with access Viewer but not full version of Access?
    By Shanyn in forum Access Tables & Databases
    Replies: 1
    Last Post: 10-22-2014, 01:14 PM
  3. Parsing HTML Tables for Storage in Access
    By Stopwatch in forum Access Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2014, 12:31 PM
  4. Excel ws into outlook html body with current html signature
    By Cadelanne in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 01-29-2014, 09:03 AM
  5. Pulling SharePoint data from Access - HTML tags are showing up. :(
    By Ragnaros in forum Microsoft Windows Help
    Replies: 0
    Last Post: 04-24-2013, 05:43 PM
  6. convert formated excel column to html source text with html tags
    By julia81 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-19-2011, 04:22 PM
  7. How to add HTML header/footer to export as HTML?
    By JGCA in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-08-2009, 04:29 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1