Why the access database can be read but can not write.

[Bennett F. Dill]

John, have you tried giving write permissions to the website anonymous user
account on the database file in question?

 

[John Smith]

hello:
I progams in asp as following codes, but result in
"|10|80004005|[Microsoft][ODBC_Microsoft_Access_Driver]_Operation_must_use_a
n_updateable_query." in the internet access log server file. The operation
system I am in using is that the Evaluation english verson of windows server
2003. How can I resolve this problem ? The database can be read , but can
not write. the first time I use of this verson of windows 2003, the asp can
work normally, but when I reinstall windows 2003 days before, it can not
work. I using the systemdsn datasource. How can I resolve this problem ?
Thank you very much.
asp codes:
<%
set cn_words=server.CreateObject ("adodb.connection")
set rs_count=server.CreateObject ("adodb.recordset")
cn_words.Open "updatetest"
sql_insert="insert into test (name, age) values ('test', '30')"
cn_words.Execute sql_insert
sql_count="select * from test"
rs_count.Open sql_count, cn_words, 1,1
%>

 

[Val Mazur]

Hi John,

Your query has a NAME field, which is a reserved word. I think this is a
problem. try to warp it into the square brackets

insert into test ([name], age) values ('test', '30')

 

[John Smith]

Bennett F. Dill:
Thank you very much. I had resolved the problem using the method you
provided. At the first time I installed windows 2003, the disk file system
type is FAT32, the second time I installed it, using of file system type of
NTFS. Maybe it is this change cause the problem. I know that in NTFS, some
security method will affect but not in FAT32.
Here is another problem, I want to reply to you in the newsgroup, but
didn't know how to config the exchange server preferences. I am in using of
Outlook Express 6.0. Can you tell me about this?
I've tried to install exchange server 2003 on my computer, but when it
config for registry of Miscellaneous Atom, it stop there waiting, and do
nothing again. How can I resolve this problem? The following is the log
file' content for exchange server 2003 evaluation verson:

.......
[02:26:28] Configuring registry entries for Services Atom
[02:26:28] Entering CRegistryManager::ScProcessFile
[02:26:28] ++++ Starting interpreter on file d:\exchange
2003\e3eevaeng\setup\i386\exchange\services.ins ++++ -- ID:31258 --
[02:26:28] Interpreting line <RegisterDLL:\Program
Files\Exchsrvr\bin\cdo.dll> -- ID:31259 --
[02:26:29] Leaving CRegistryManager::ScProcessFile
[02:26:29] Leaving CBaseAtom(Services Atom)::ScAddRegistryKeys
[02:26:29] Creating IIS Metabase objects for Services Atom
[02:26:29] Entering CBaseAtom(Services Atom)::ScAddShortcuts
[02:26:29] Leaving CBaseAtom(Services Atom)::ScAddShortcuts
[02:26:29] Leaving CBaseAtom(Services Atom)::ScForklift
[02:26:29] Leaving CBaseServiceAtom(Services Atom)::ScForklift
[02:26:29] Completed Disaster Recovery of Services Atom sub-component
[02:26:29] Beginning Disaster Recovery of Web Forms sub-component
[02:26:29] Entering CBaseServiceAtom(Web Forms)::ScForklift
[02:26:29] Entering CBaseServiceAtom(Web Forms)::ScCreateAtomServices
[02:26:29] Leaving CBaseServiceAtom(Web Forms)::ScCreateAtomServices
[02:26:29] Entering CBaseAtom(Web Forms)::ScForklift
[02:26:29] Entering CBaseAtom(Web Forms)::ScAddRegistryKeys
[02:26:29] Configuring registry entries for Web Forms
[02:26:29] Entering CRegistryManager::ScProcessFile
[02:26:29] ++++ Starting interpreter on file d:\exchange
2003\e3eevaeng\setup\i386\exchange\webforms.ins ++++ -- ID:31258 --
[02:26:29] Interpreting line <RegisterDLL:\Program
Files\Exchsrvr\exchweb\bin\exwform.dll> -- ID:31259 --
[02:26:31] Interpreting line <OpenMachineKey:Software\Microsoft\Exchange> --
ID:31259 --
[02:26:31] Interpreting line <CreateKey:Forms> -- ID:31259 --
[02:26:31] Interpreting line <CloseKey:> -- ID:31259 --
[02:26:34] Interpreting line
<OpenMachineKey:Software\Microsoft\Exchange\Forms> -- ID:31259 --
[02:26:34] Interpreting line <ReplaceString:NameForE2K;D:\Program
Files\Exchsrvr\exchweb\bin\exwform.dll> -- ID:31259 --
[02:26:34] Interpreting line <ReplaceString:ResourceDllBasePath;D:\Program
Files\Exchsrvr\res\> -- ID:31259 --
[02:26:34] Interpreting line <CloseKey:> -- ID:31259 --
[02:26:34] Interpreting line
<OpenMachineKey:Software\Microsoft\Exchange\Setup> -- ID:31259 --
[02:26:34] Interpreting line <ReplaceString:BrowseCap.ini;D:\Program
Files\Exchsrvr\bin\browscap.ini> -- ID:31259 --
[02:26:34] Interpreting line <CloseKey:> -- ID:31259 --
[02:26:34] Leaving CRegistryManager::ScProcessFile
[02:26:34] Leaving CBaseAtom(Web Forms)::ScAddRegistryKeys
[02:26:34] Creating IIS Metabase objects for Web Forms
[02:26:34] Entering CBaseAtom(Web Forms)::ScAddShortcuts
[02:26:34] Leaving CBaseAtom(Web Forms)::ScAddShortcuts
[02:26:34] Leaving CBaseAtom(Web Forms)::ScForklift
[02:26:34] Leaving CBaseServiceAtom(Web Forms)::ScForklift
[02:26:34] Completed Disaster Recovery of Web Forms sub-component
[02:26:34] Beginning Disaster Recovery of Microsoft Exchange WMI Providers
sub-component
[02:26:34] Entering CBaseServiceAtom(Microsoft Exchange WMI
Providers)::ScForklift
[02:26:34] Entering CAtomWMIProv::ScCreateAtomServices
[02:26:34] Leaving CAtomWMIProv::ScCreateAtomServices
[02:26:34] Entering CBaseAtom(Microsoft Exchange WMI Providers)::ScForklift
[02:26:34] Entering CAtomWMIProv::ScAddRegistryKeys
[02:26:34] Entering CBaseAtom(Microsoft Exchange WMI
Providers)::ScAddRegistryKeys
[02:26:34] Configuring registry entries for Microsoft Exchange WMI Providers
[02:26:34] Entering CRegistryManager::ScProcessFile
[02:26:34] ++++ Starting interpreter on file d:\exchange
2003\e3eevaeng\setup\i386\exchange\wmiprov.ins ++++ -- ID:31258 --
[02:26:35] Interpreting line <CreateProcess:\Program
Files\Exchsrvr\bin;"D:\Program Files\Exchsrvr\bin\exmgmt.exe"
/install;60000> -- ID:31259 --
[02:26:35] Process created ... waiting (60000)
[02:26:38] Process has exited with 00000000
[02:26:38] Interpreting line
<CreateProcess:\WINDOWS\system32\WBEM;"D:\WINDOWS\system32\WBEM\mofcomp.ex
e" -class:forceupdate "D:\WINDOWS\system32\WBEM\msgtrk.mof";600000> --
ID:31259 --
[02:26:38] Process created ... waiting (600000)
[02:26:41] Process has exited with 00000000
[02:26:41] Leaving CRegistryManager::ScProcessFile
[02:26:41] Leaving CBaseAtom(Microsoft Exchange WMI
Providers)::ScAddRegistryKeys
[02:26:41] Leaving CAtomWMIProv::ScAddRegistryKeys
[02:26:41] Creating IIS Metabase objects for Microsoft Exchange WMI
Providers
[02:26:41] Entering CBaseAtom(Microsoft Exchange WMI
Providers)::ScAddShortcuts
[02:26:41] Leaving CBaseAtom(Microsoft Exchange WMI
Providers)::ScAddShortcuts
[02:26:41] Leaving CBaseAtom(Microsoft Exchange WMI Providers)::ScForklift
[02:26:41] Leaving CBaseServiceAtom(Microsoft Exchange WMI
Providers)::ScForklift
[02:26:41] Completed Disaster Recovery of Microsoft Exchange WMI Providers
sub-component
[02:26:41] Beginning Disaster Recovery of Miscellaneous Atom sub-component
[02:26:41] Entering CBaseServiceAtom(Miscellaneous Atom)::ScForklift
[02:26:41] Entering CBaseServiceAtom(Miscellaneous
Atom)::ScCreateAtomServices
[02:26:41] Leaving CBaseServiceAtom(Miscellaneous
Atom)::ScCreateAtomServices
[02:26:41] Entering CBaseAtom(Miscellaneous Atom)::ScForklift
[02:26:41] Entering CBaseAtom(Miscellaneous Atom)::ScAddRegistryKeys
[02:26:41] Configuring registry entries for Miscellaneous Atom
[02:26:41] Entering CRegistryManager::ScProcessFile
[02:26:41] ++++ Starting interpreter on file d:\exchange
2003\e3eevaeng\setup\i386\exchange\Misc.ins ++++ -- ID:31258 --
[02:26:41] Interpreting line <CreateProcessSafe:d:\exchange
2003\e3eevaeng\setup\i386\exchange\wmi;"d:\exchange
2003\e3eevaeng\setup\i386\exchange\wmi\wmicons.exe" /s;4294967295> --
ID:31259 --
[02:26:41] Process created ... waiting (-1)



Thank you very much!