Microsoft Access Help
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
 
 
User Name:
Password:
Remember me
Go Back   ASP Free ForumsDatabaseMicrosoft Access Help

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread ASP Free Forums Sponsor:
  #1  
Old November 8th, 2003, 12:31 PM
Smithy Smithy is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Posts: 4 Smithy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Trouble Adding Data Into MS Access DB

Hey guys, Im rather new to this ASP stuff and have been working for HOURS trying to send just a few lines of text into my access databse. Any ideas?

Code:

strConnect is defined in another asp file as:

strConnect = "DRIVER={Microsoft Access Driver (*.mdb)};DBQ=" & Server.MapPath("match_admin_db.mdb")

<%
Dim Conn, handle, password, access, sql_insert

Set Conn = Server.CreateObject("ADODB.Connection")
Conn.ConnectionString = strConnect
Conn.Open

handle = Request.Form("player_handle")
password = Request.Form("player_password")
access = Request.Form("player_access")

sql_insert = "insert into players (player_handle, player_password, player_access) values ('handle', 'password', 'access')"

Conn.execute sql_insert

Conn.Close
Set Conn = Nothing
%>

When I run it I get this error:

Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/MatchAdminASP/do_add_player.asp, line 31

Anyone know how to fix this problem?

Also if I use an access databse will I be able to run it on any comp/webhost that can serve ASP or will I need to edit secutity settings for the db and such...thanks.

Regards

Reply With Quote
  #2  
Old November 8th, 2003, 02:58 PM
Doug G Doug G is offline
Grumpier Old Moderator
ASP Free God 11th Plane (10000 - 10499 posts)
 
Join Date: Sep 2003
Posts: 10,143 Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level)Doug G User rank is First Lieutenant (10000 - 20000 Reputation Level) 
Time spent in forums: 3 Weeks 4 Days 22 h 33 m
Reputation Power: 181

Reply With Quote
  #3  
Old November 8th, 2003, 04:12 PM
Smithy Smithy is offline
Registered User
ASP Free Newbie (0 - 499 posts)
 
Join Date: Nov 2003
Posts: 4 Smithy User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
Much thanks o wise one. /me bows to Doug G That did that job but I think your FAQ might have the same problem... Thanks a ton!

Regards

Reply With Quote
Reply

Viewing: ASP Free ForumsDatabaseMicrosoft Access Help > Trouble Adding Data Into MS Access DB


Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Rate This Thread:


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

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 5 hosted by Hostway
Stay green...Green IT