Operation must use an updateable query

[MacataQ]

hello all
i have see this problem posted in here before and have read/tried the suggested solutions
if someone could take a lot at this , and give any advice , i would appreciate it
i am trying to use a DNS-less connection

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


Browser Type:
Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1)

Page:
POST 82 bytes to /users.asp

POST Data:
action=insert&index=1&username-1=*******&password1-1=*******&password2-1=********

Time:
Saturday, August 06, 2005, 8:55:07 PM



error occurs here:

set rs = DbConn.Execute(sql)

okay i think i got thru this one by following along with the links

now i recive a different error at the same spot . only now it is saying
"syntax error in INSERT INTO statement"
.... is the light at the end of the tunnel a train?

Mac

[pclement]

Very likely a permissions problem. See the following:

http://support.microsoft.com/default.aspx?scid=kb;en-us;316675

I would also recommend using the Jet OLEDB provider for your DSN-less connection:

http://www.carlprothman.net/Default.aspx?tabid=87#OLEDBProviderForMicrosoftJet

[MacataQ]

hey Paul

thanx for the links
a couple of things i forgot to mention in previous post
which may or may not have a bearing on my problem
i am using ordinary ASP and i only want to have these pages available to one computer(at present)with IIS running. i want to be able to test out the application without worrying about security issues and such. i want to see that it functions properly before i open it up to the web.
i am using a free app i got off the net(all the asp,css and mdb files included) to get started...do i need to set up IIS and all permissions and such before i try to run the app, or can/should i do that afterwards? also will i be able to use the standard ADODB connection method?
as always thank you for your patience in advance

Mac