Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access ASP
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access ASP Using ASP with Microsoft Access databases. For Access questions not specific to ASP, please use the Access forum. For more ASP forums, please see the ASP forum category.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access ASP section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old September 22nd, 2004, 09:41 AM
Registered User
 
Join Date: Sep 2004
Location: , , United Kingdom.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default Access database won't update?

Hello, i was hoping that someone could help me with this database problem. I have a dsn connection to my access database that works fine, but when i try to update it through a form on my website it won't work and i get a page with an internal server error. I have also updated the database in access and it will not show any new updates in the dreamweaver database pannel. When i open the database directly in access the records show up fine. I have updated both databases in local view and in my local root folder. but still nothing happens. Could anyone please help me? thanks jula

here is the code for my form which won't update
<form method="POST" action="<%=MM_editAction%>" name="form1">
        <table align="center">
          <tr valign="baseline">
            <td nowrap align="right">CustomerID:</td>
            <td>
              <input type="text" name="CustomerID" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">ContactFirstName:</td>
            <td>
              <input type="text" name="ContactFirstName" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">ContactLastName:</td>
            <td>
              <input type="text" name="ContactLastName" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">BillingAddress:</td>
            <td>
              <input type="text" name="BillingAddress" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">City:</td>
            <td>
              <input type="text" name="City" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">StateOrProvince:</td>
            <td>
              <input type="text" name="StateOrProvince" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">PostalCode:</td>
            <td>
              <input type="text" name="PostalCode" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">Country/Region:</td>
            <td>
              <input type="text" name="CountryRegion" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">PhoneNumber:</td>
            <td>
              <input type="text" name="PhoneNumber" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">EmailAddress:</td>
            <td>
              <input type="text" name="EmailAddress" value="" size="32">
            </td>
          </tr>
          <tr valign="baseline">
            <td nowrap align="right">&nbsp;</td>
            <td>
              <input type="submit" value="Insert record">
            </td>
          </tr>
        </table>
        <input type="hidden" name="MM_insert" value="form1">
      </form>

Reply With Quote
  #2 (permalink)  
Old September 22nd, 2004, 12:43 PM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

I'd say if you're having troubles updating a database, it makes more sense to post the ASP code than the HTML, don't you think?? ;)

To get the detailed error message, check out this FAQ:

http://imar.spaanjaars.com/QuickDocID.aspx?QUICKDOC=264

Then post the error and the code that causes the error, so we can take a look....

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Rub 'Til It Bleeds by P.J. Harvey (Track 4 from the album: Rid Of Me) What's This?
Reply With Quote
  #3 (permalink)  
Old September 22nd, 2004, 05:13 PM
Registered User
 
Join Date: Sep 2004
Location: , , United Kingdom.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Imar, I'm new to asp, i hope this helps

<%@LANGUAGE="JAVASCRIPT" CODEPAGE="1252"%>

<%
// *** Edit Operations: declare variables

// set the form action variable
var MM_editAction = Request.ServerVariables("SCRIPT_NAME");
if (Request.QueryString) {
  MM_editAction += "?" + Server.HTMLEncode(Request.QueryString);
}

// boolean to abort record edit
var MM_abortEdit = false;

// query string to execute
var MM_editQuery = "";
%>
<%
// *** Insert Record: set variables

if (String(Request("MM_insert")) == "form1") {

  var MM_editConnection = MM_customer_STRING;
  var MM_editTable = "Customers";
  var MM_editRedirectUrl = "aboutus.asp";
  var MM_fieldsStr = "CustomerID|value|ContactFirstName|value|ContactLa stName|value|BillingAddress|value|City|value|State OrProvince|value|PostalCode|value|CountryRegion|va lue|PhoneNumber|value|EmailAddress|value";
  var MM_columnsStr = "CustomerID|none,none,NULL|ContactFirstName|',none ,''|ContactLastName|',none,''|BillingAddress|',non e,''|City|',none,''|StateOrProvince|',none,''|Post alCode|',none,''|Country/Region|',none,''|PhoneNumber|',none,''|EmailAddres s|',none,''";

  // create the MM_fields and MM_columns arrays
  var MM_fields = MM_fieldsStr.split("|");
  var MM_columns = MM_columnsStr.split("|");

  // set the form values
  for (var i=0; i+1 < MM_fields.length; i+=2) {
    MM_fields[i+1] = String(Request.Form(MM_fields[i]));
  }

  // append the query string to the redirect URL
  if (MM_editRedirectUrl && Request.QueryString && Request.QueryString.Count > 0) {
    MM_editRedirectUrl += ((MM_editRedirectUrl.indexOf('?') == -1)?"?":"&") + Request.QueryString;
  }
}
%>
<%
// *** Insert Record: construct a sql insert statement and execute it

if (String(Request("MM_insert")) != "undefined") {

  // create the sql insert statement
  var MM_tableValues = "", MM_dbValues = "";
  for (var i=0; i+1 < MM_fields.length; i+=2) {
    var formVal = MM_fields[i+1];
    var MM_typesArray = MM_columns[i+1].split(",");
    var delim = (MM_typesArray[0] != "none") ? MM_typesArray[0] : "";
    var altVal = (MM_typesArray[1] != "none") ? MM_typesArray[1] : "";
    var emptyVal = (MM_typesArray[2] != "none") ? MM_typesArray[2] : "";
    if (formVal == "" || formVal == "undefined") {
      formVal = emptyVal;
    } else {
      if (altVal != "") {
        formVal = altVal;
      } else if (delim == "'") { // escape quotes
        formVal = "'" + formVal.replace(/'/g,"''") + "'";
      } else {
        formVal = delim + formVal + delim;
      }
    }
    MM_tableValues += ((i != 0) ? "," : "") + MM_columns[i];
    MM_dbValues += ((i != 0) ? "," : "") + formVal;
  }
  MM_editQuery = "insert into " + MM_editTable + " (" + MM_tableValues + ") values (" + MM_dbValues + ")";

  if (!MM_abortEdit) {
    // execute the insert
    var MM_editCmd = Server.CreateObject('ADODB.Command');
    MM_editCmd.ActiveConnection = MM_editConnection;
    MM_editCmd.CommandText = MM_editQuery;
    MM_editCmd.Execute();
    MM_editCmd.ActiveConnection.Close();

    if (MM_editRedirectUrl) {
      Response.Redirect(MM_editRedirectUrl);
    }
  }

}
%>
<%
var Recordset1 = Server.CreateObject("ADODB.Recordset");
Recordset1.ActiveConnection = MM_customer_STRING;
Recordset1.Source = "SELECT * FROM Customers";
Recordset1.CursorType = 0;
Recordset1.CursorLocation = 2;
Recordset1.LockType = 1;
Recordset1.Open();
var Recordset1_numRows = 0;
%>

And all my settings are the same as the error FAQ link you gave me, and it still comes up with the same error
HTTP 500 - Internal server error
Internet Explorer

 any ideas? cheers jula



Reply With Quote
  #4 (permalink)  
Old September 23rd, 2004, 01:02 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Tat's weird. You should get detailed info when you change the settings in IE. Can you test a different type of browser and see if you get a different error message?

Are you running your own Web server? The error may be caused by a security issue where the Web server account (IUSR_MachineName) does not have permissions to read and/or write from the database....

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #5 (permalink)  
Old September 23rd, 2004, 08:42 AM
Registered User
 
Join Date: Sep 2004
Location: , , United Kingdom.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello, yeh i am running my own web server but it has permissons to the database. When i first set up the connection it wouldn't show any tables so i went
through it setting up the permissons, and then i could see the tables. I don't understand why it won't update though, anyway i'll keep trying cheers

Reply With Quote
  #6 (permalink)  
Old September 24th, 2004, 10:24 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

To what account did you grant access? Your account alone is not enough; the Web server needs access as well.


Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Strangers by Portishead (Track 3 from the album: Dummy) What's This?
Reply With Quote
  #7 (permalink)  
Old September 26th, 2004, 07:36 AM
Registered User
 
Join Date: Sep 2004
Location: , , United Kingdom.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

hi, How do i grant access for the web server?, i thought giving it permissions through IIS was enough.

Reply With Quote
  #8 (permalink)  
Old September 26th, 2004, 07:53 AM
Imar's Avatar
Wrox Author
Points: 72,055, Level: 100
Points: 72,055, Level: 100 Points: 72,055, Level: 100 Points: 72,055, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,086
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

No, that's not enough. The Web server (usually the IUSR_MachineName account) needs to be able to read and write to the files on the (NTFS) disk as well.

Check out this FAQ for a detailed explanation: http://imar.spaanjaars.com/QuickDocID.aspx?QUICKDOC=290

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
Reply With Quote
  #9 (permalink)  
Old September 26th, 2004, 05:46 PM
Registered User
 
Join Date: Sep 2004
Location: , , United Kingdom.
Posts: 8
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello Imar, It's all working now, i followed the FAQ you gave me and
it all works now. Thankyou so much, i can stop pulling my hair out now cheers jula

Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
!!HELP! trying to update an Access database brawny4 VB Databases Basics 4 April 24th, 2007 02:07 PM
Help!!! Cannot Update, Delete from Access database dreamzentrue ADO.NET 7 November 3rd, 2005 06:11 PM
Allow SQL to update an Access database levinho Classic ASP Databases 7 November 11th, 2003 08:32 AM
Database update access inershado Access ASP 1 September 23rd, 2003 11:26 PM



All times are GMT -4. The time now is 11:52 AM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.