Forums
This topic is locked
UltraDev and Access Database
Posted 10 Dec 2001 22:19:59
1
has voted
10 Dec 2001 22:19:59 Terry Bettendorf posted:
I want to try out UltraDev 4 in adding records to a database. I want to host the database and site from a W2K machine running IIS 5.0. I create the DSN connection and when I test the connection it is successful. I have tried both linking through a connection string, and by using the DSN with the driver. The page that contains the form loads up fine, testing it from the web, however when I go to submit the page and add the records the database, which is Access, it gives me the error listed below. Any ideas would be appreciated thanks.the page is at 170.140.143.11/index.asp
Terry Bettendorf
HTTP 500.100 - Internal Server Error - ASP error
Internet Information Services
--------------------------------------------------------------------------------
Technical Information (for support personnel)
Error Type:
Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Operation must use an updateable query.
/index.asp, line 90
Browser Type:
Mozilla/4.0 (compatible; MSIE 5.01; Windows NT 5.0)
Page:
POST 163 bytes to /index.asp
POST Data:
EMPLOYEEID=25487&FIRSTNAME=terry&LASTNAME=bettendorf&PHONE=404-577-4383&STARTDATE=12%2F01%2F01&TITLE=MR.&DEPARTMENT=&EXTENSION=&EMAIL=&PHOTO=&NOTES=&MM_insert=true
Time:
Monday, December 10, 2001, 1:39:44 PM
Replies
Replied 10 Dec 2001 22:21:59
10 Dec 2001 22:21:59 Terry Bettendorf replied:
Just another note, I have made sure my fields match up as far as data type and so on, and I do not have an large values being submitted either. Thanks. Please help me with this, haha.!
Replied 10 Dec 2001 22:44:21
10 Dec 2001 22:44:21 Jeff Hansen replied:
You need to make sure that you have given 'everyone' full control rights to your database file and that it is not marked 'read only'. You are given that error because the rights are blocking the file from being updated.
Jeff
Jeff