Access database not writing

[Kris]

I have a website using a windows server and i recently
put in a calendar program (Ocean12) that uses an Access
database. I get a 500 error because the database wont
update itself. What should I do since I can't CHMOD
anything on a windows server?

 

[Jim Carlock]

Usually a database on an IIS server will use ODBC or relative
paths or hardcoded paths. What kind of code is bombing out on
you? Is your code on an IIS server?

If you place the general code here, we'll be able to help you a
little better. Without knowing certain things, it'll be just too hard
to guess at what's happening.

What exactly is error 500? It sounds like an IIS server code, but
I thought those started with 400. <g>

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


I have a website using a windows server and i recently
put in a calendar program (Ocean12) that uses an Access
database. I get a 500 error because the database wont
update itself. What should I do since I can't CHMOD
anything on a windows server?

 

[Guest]

here is the error message:
2004-03-05 05:00:11 64.233.203.125 - W3SVC1168 CHIANA
208.255.91.29 80 POST /cal/admin/settings2.asp
|56|80004005|[Microsoft][ODBC_Microsoft_Access_Driver]
_Cannot_update.__Database_or_object_is_read-only. 500 0
965 1257 94 HTTP/1.1 www.sehs.us Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322)
ASPSESSIONIDQARBBDDD=ADPBNIODJIPMPMDKDKHLBLAM -

 

[Jim Carlock]

Looks like it might be a read only file, or stuck in a readonly folder.

I know how to get around this if you're using FrontPage... All that
comes to mind is turn the Read Only attribute off before you
upload the file. This will take care of that problem. It might be
that the folder in which it's located in has Read Only permissions.

That could be a number of reasons. Either the folder is tagged as
readonly and all of it's contents assume the readonly attribute, or
the process is being started by a user that doesn't have the needed
permissions.

How do you upload the files? FTP?

First check the attribute on the database file itself isn't readonly.
I think you can just right click on the folders or if you're using an
FTP program, the FTP program should allow you to set the
attributes on the folders.

Let us know if that helps at all.

--
Jim Carlock
http://www.microcosmotalk.com/
Post replies to the newsgroup.


here is the error message:
2004-03-05 05:00:11 64.233.203.125 - W3SVC1168 CHIANA
208.255.91.29 80 POST /cal/admin/settings2.asp
|56|80004005|[Microsoft][ODBC_Microsoft_Access_Driver]
_Cannot_update.__Database_or_object_is_read-only. 500 0
965 1257 94 HTTP/1.1 www.sehs.us Mozilla/4.0+
(compatible;+MSIE+6.0;+Windows+NT+5.1;+.NET+CLR+1.1.4322)
ASPSESSIONIDQARBBDDD=ADPBNIODJIPMPMDKDKHLBLAM -