Re: Only want to insert a record
- From: "Daniel Crichton" <msnews@xxxxxxxxxxxxxxxxxx>
- Date: Tue, 10 Jan 2006 12:27:18 -0000
"Dave" <dave5398@xxxxxxxxxxxxxx> wrote in message
news:eOuM54dFGHA.3892@xxxxxxxxxxxxxxxxxxxxxxx
> I'm trying again to develop my web application locally using IIS and asp
> scripting with a local MS Access database. I have never managed to update
> or insert a record using scripting. I can seem to display records ok but
> any attempt to amend records seems to fail. I tried using recordsets then
> read in MS documentation you should execute a direct command. My latest
> failed attempt is this:
>
> ConnectionString = ".....etc"
> Conn.Mode=3
> Conn.Open(ConnectionString)
> sql="INSERT INTO Users (Name, Password) VALUES ('Jim', 'Hello')"
> Conn.Execute sql
>
> The sql works fine within Access itself. When executed within an asp page
> however I get:
>
> Error Type:
> Microsoft JET Database Engine (0x80004005)
> Operation must use an updateable query.
>
> Can anyone please help, I've been trying for months.
Do you have a primary key on that table? The error message suggests not.
Also try adding [] around your table and column names - in some system Name
and Password are reserved words, and ADO or the OLE DB driver may be trying
to interpret them as such. Also drop the Mode property, I've never needed to
use this myself as I believe the default is to not set any permissions,
which lets you do whatever your user permissions allow.
sql="INSERT INTO [Users] ([Name], [Password]) VALUES ('Jim', 'Hello')"
Dan
.
- Follow-Ups:
- Re: Only want to insert a record
- From: Dave
- Re: Only want to insert a record
- References:
- Only want to insert a record
- From: Dave
- Only want to insert a record
- Prev by Date: Only want to insert a record
- Next by Date: Re: Only want to insert a record
- Previous by thread: Only want to insert a record
- Next by thread: Re: Only want to insert a record
- Index(es):
Relevant Pages
- Only want to insert a record
... I'm trying again to develop my web application locally using IIS and asp ...
scripting with a local MS Access database. ... The sql works fine within
Access itself. ... (microsoft.public.data.ado) - Re: Only want to insert a record
... >> scripting with a local MS Access database. ... When executed
within an asp page ... Any reason why calling ADO from a script should be different
to ... (microsoft.public.data.ado) - Re: Only want to insert a record
... >>> scripting with a local MS Access database. ... When executed
within an asp ... (microsoft.public.data.ado) - Re: IIS 5 100% CPU troubleshooting tools - IISState?
... strong correlation and I put the site into high isolation (and the customer
... ASP requests queued -- and they seemed stuck, ... In this case he is using an
Access database with a connection string ... (microsoft.public.inetserver.iis) - Re: asp login page
... Not supported on Windows Servers. ... and tutorials on my web site regarding
ASP: http://www.takempis.com. ... who did the login scripting? ... (microsoft.public.frontpage.client)