|
|
|||||||||
|
|||||||||
|
|||||||||
| |
||
| |||||||||
![]() |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
|
#1
|
|||
|
|||
|
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 |
|
#2
|
|||
|
|||
|
|
|
#3
|
|||
|
|||
|
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 |
![]() |
| Viewing: ASP Free Forums > Database > Microsoft Access Help > Trouble Adding Data Into MS Access DB |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
|
|