Database Engine Error 80040e07
JET Database Engine error '80040e07' The SitePoint Forums have moved. You can now find them here. This forum is now closed to new posts, but you can browse existing content. You can find out more information about the move and how to open a new account (if necessary) here. If you get stuck you can get support by emailing forums@sitepoint.com If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. SitePoint Sponsor User Tag List Page 1 of 3 123 Last Jump to page: Results 1 to 25 of 56 Thread: Microsoft JET Database Engine error '80040e07' Thread Tools Show Printable Version Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode Feb 14, 2013,17:26 #1 DoomedVash View Profile View Forum Posts SitePoint Enthusiast Join Date Feb 2013 Posts 26 Mentioned 0 Post(s) Tagged 0 Thread(s) Microsoft JET Database Engine error '80040e07' Hello all! I hope you guys can help me. I have an old ASP-based gaming event system running on my Windows Server 2008 R2 with ASPClassic enabled. Everything works fine so. Until I try to calculate the statistics for an event. Then I get this error: Microsoft JET Database Engine error '80040e07' Data type mismatch in criteria expression. /wargames/includes/include.asp, line 3815 This is my code: Code: function RecalcGameRC(iGameID) ' Set up variables and structures dim sDebugResults dim SQL, rsMatches, rsPlayer, rsPoints, iMaxClubPlayers, iMaxGamesPlayed, iMinGamesHosted, iMaxAttritionRt dim iGames, vWarsList, index, iWarID, sMatchList, sPlayerName, iUniquePlayersIndex, vPlayerMatches, iMaxUPP, iMaxhrp, iMaxVictoryRt dim iRanking, iMaxPP, iAveragePlayerRanking, iPlayerID, iPoi
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ASP Error - Microsoft JET Database Engine error '80040e07' up vote 1 down vote favorite im having trouble with a registration form connecting to a database and storing the data, below is the error im getting. Microsoft http://www.sitepoint.com/forums/showthread.php?975855-Microsoft-JET-Database-Engine-error-80040e07 JET Database Engine error '80040e07' Data type mismatch in criteria expression. /mus0280/coursework2/storefuncs.asp, line 330 This is the code snipet, i have have checked if the data types are the same in the database and the whole website. ' Add New User to Database sqlString = "INSERT INTO users ( " &_ "user_username, " &_ "user_password, " &_ "user_email," &_ "user_address, " &_ "user_city," &_ "user_postcode," &_ "user_cardnumber, " &_ "user_cardtype, " &_ "user_cardexpiremonth," &_ "user_cardexpireyear," &_ "user_cardname," &_ "user_HTML" &_ ") VALUES http://stackoverflow.com/questions/8810959/asp-error-microsoft-jet-database-engine-error-80040e07 ( " &_ " '" & fixQuotes( newusername ) & "', " &_ " '" & fixQuotes( newpassword ) & "', " &_ " '" & fixQuotes( email ) & "', " &_ " '" & fixQuotes( address ) & "', " &_ " '" & fixQuotes( city ) & "', " &_ " '" & fixQuotes( postcode ) & "', " &_ " '" & fixQuotes( cardnumber ) & "', " &_ " '" & cardtype & "', " &_ " '" & cardexpiremonth & "', " &_ " '" & cardexpireyear & "', " &_ " '" & fixQuotes( cardname ) & "', " &_ " " & html & " " &_ ")" Con.Execute sqlString - this is line 330 database asp-classic jet share|improve this question edited Jan 10 '12 at 22:06 Glenn Slaven 19.7k2187149 asked Jan 10 '12 at 21:46 mussi89 3229 1 can you print out the string so we can see it's final outcome ? –Jordan Jan 10 '12 at 21:48 hi sorry for the unedited code, new here, anyway i figured out that the problem was with the write permissions on the folder. –mussi89 Jan 10 '12 at 22:10 Wow, what an obtuse error message for that problem eh? –Jordan Jan 10 '12 at 22:35 2 @mussi89 please explain your fix as an answer so that people who find this from Google are able to easily see the fix. –akiller
your SELECT database engine SQL query statement. The following table illustrates the delimiters required for each type of field: Field Type (Access) Field database engine error Type (SQL Server) Delimiter Text Char, varChar ' Numeric Any numeric type