inetserver asp components: When I start my Site on localhost (W2003Server, IIS, ASP, VB-DLL), it works
fine, when I start the Site from a WinXP-Pro, I get the following error,
every time I want to update or insert a record in the access-mdb:

-2147467259, -198839259, Operation must use an updateable query., (#ProcNo:
103), ErrorLine: 0, Microsoft JET Database Engine,

I have absolut no idea, where to search!
Please help
tia

[quoted text, click to view]

This worked for me:

1) Open Control Panel then click Folder Options then scroll to the
bottom and turn off "Simple File Sharing"

2) Open Windows Explorer, right-click on the database's folder, click
Properties, click on the (now revealed) Security tab then select Everyone
then click the "Write" checkbox the click "Apply".

Thanks, but it does not work for me...

I set up a virtual directory in IIS to my bin-directory with
virtual directory: read- and write-permission
authentication and accesscontrol: anonymous access disabled
integrated windows
authentication enabled
this directory contains the dll-files and the mdb-database-file
-----
Then I selected properties of bin-directory in explorer:
share this folder enabled
maximum allowed enabled
permissions everyone full control enabled
-----
This is the code for opening the connection to the mdb:
Set nwDB.cnn = New ADODB.Connection
cDB = nwDB.DBPathName & "\" & nwDB.DBName
With nwDB.cnn
.ConnectionTimeout = 40
.CursorLocation = adUseServer
.Mode = adModeReadWrite
.Provider = nwDB.DBConnString
.Open ConnectionString:=cDB, UserID:=nwDB.DBUser, Password:=""
nwDB.isConnected = True
DoEvents
End With
-----
This is an example for a sql-statement, which causes the error:
UPDATE Tbl_Job SET job_inputtime = '27.05.2005', job_validtime =
'27.05.2005', job_user = 'xy', job_action_id = 4, job_changetext = 'xy',
jobname = 'xy', job_cpu_id = 123, cssystem_id = 1, jobscript_name =
'xy.sh', projectuser = '', mandid = '', prodid = '', sapjobid = '', logon =
'maestro', jobdescript = 'xy', errorcontact = 'xy', abortreact_id = 1,
outofline_id = 2, ressources = 'xy', job_parm = '', errorhandling = '', misc
= '', job_state_id = 1, job_deliver_name = '', job_deliver_time = '',
job_receive_name = '', job_receive_time = '', job_user_bensl = 'xy',
job_user_timestamp = '21.09.2005 08:24:29', dummy1_id = 0, dummy2_id = 0,
dummy1 = '', dummy2 = '' WHERE job_id = 'xy' AND version = 1
-----
This is the statement to execute the sql:
Set rs = nwDB.cnn.Execute(cSQL, nCount)
-----

The clients are XP, the IIS runs on a W2003Server

Please help
tia