This is a discussion on "still having problems writing to database..." within the Classic ASP section. This forum, and the thread "still having problems writing to database... are both part of the Program Your Website category.
|
|
|
|
|
 |
||
still having problems writing to database...
|
||
| Notices |
 |
|
|
LinkBack | Thread Tools |
Aug 25th, 2004, 19:00
|
||||
|
||||
|
still having problems writing to database...
this is the error i get when i try to submit to a database:
Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /login/slog/regcheck.asp, line 70 but this is my query (line 70): Set objRS = conn.execute("INSERT INTO users(uid,pwd,email,website) VALUES ('" & user & "','" & pword & "','" & email & "','" & web & "')") someone please tell me whats going wrong!!! |
|
|
|
Aug 25th, 2004, 20:34
|
|||
|
|||
|
is uid an auto-generated field?
|
|
Aug 25th, 2004, 20:44
|
||||
|
||||
|
nope, they are all plain text fields
|
|
Aug 25th, 2004, 22:44
|
|||
|
|||
|
I think you probably don't have the correct permissions set for your Access file. The system needs to have read, write, modify permission for the file for you to be able to do anything more than just read from the db.
|
|
Aug 26th, 2004, 06:43
|
||||
|
||||
|
how do you set those permissions?
|
|
Aug 26th, 2004, 07:02
|
|||
|
|||
|
Is it your server or a shared one?
|
|
Aug 26th, 2004, 07:41
|
||||
|
||||
|
currently im just running it off of IIS, because i don't have an ASP server...
|
|
Aug 26th, 2004, 08:58
|
|||
|
|||
|
It varies based on the OS a little, but you want to right click on the mdb file or the folder containing it and select Security. Under the permissions give Full Permissions to the IUSR_machinename.
|
|
Aug 26th, 2004, 09:52
|
||||
|
||||
|
Hi Ben... you may want to see this:-
Access Write Permissions
__________________
Rob - SEO Specialist Owner & Founder of Webforumz.com I am currently unavailable for private work
Last Blog Entry: Creative Labs threaten developer over home made drivers.... (Apr 1st, 2008)
|
|
Aug 26th, 2004, 16:20
|
||||
|
||||
|
thanks rob, i'll have a look and see if it works when i get home!
|
|
| Tags |
| still, having, problems, writing, database |
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| [SOLVED] Data From Form To Database Input Problems | longstand | PHP Forum | 6 | Oct 12th, 2007 15:54 |
| Database Update script problems | as22607 | PHP Forum | 10 | May 14th, 2007 18:08 |
| XML Code for transfering data from one SQL Server Database to another database | plolla | Other Programming Languages | 1 | Aug 3rd, 2006 18:37 |
| problems connecting to database | benbacardi | Classic ASP | 8 | Apr 15th, 2005 16:16 |
| Retrieving text from database and writing back as url | wheatus | Classic ASP | 5 | Dec 22nd, 2004 11:36 |
