If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Error trying to connect to Access Database
I am getting the following error when trying to connect to my access database:
Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; ..NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#2
|
|||
|
|||
Error trying to connect to Access Database
Without knowing what line 35 in updateCalendar_script.asp is, it's pretty
hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#3
|
|||
|
|||
Error trying to connect to Access Database
Hi Dee
Just a thought. If you are using the Access DB to hold info in your frontpage it will become non-updateable (not sure if that is a real english word ??). This may happen if you are using the folder (in frontpage) to hold information in a fold that is using the secutiry server extentions unlinked. (The same as when you hold usernames and passwords) Just a thought. Another thing have you tried cutting the d base then paste with another name (use windows explorer) -- Wayne Manchester, England. Enjoy whatever it is you do "Dee" wrote: I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#4
|
|||
|
|||
Error trying to connect to Access Database
Oh and you may want to check this site for info
http://www.webwizguide.com/asp/faq/a...tabase_faq.asp -- Wayne Manchester, England. Enjoy whatever it is you do |
#5
|
|||
|
|||
Error trying to connect to Access Database
This is what is in the calendar_script.asp string with line 35
objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#6
|
|||
|
|||
Error trying to connect to Access Database
I suspect strSQL is an Action query (INSERT INTO, UPDATE or DELETE) and that
your database isn't updatable because of the permissions issue. Are you the administrator of the server where the ASP is running? If not, ask the administrator to check the permission for you. Otherwise, select the folder in Windows Explorer, right-click and select Properties, then look on the Security tab. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message news This is what is in the calendar_script.asp string with line 35 objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#7
|
|||
|
|||
Error trying to connect to Access Database
Yes, I am the administrator. I am building a web site on my local machine.
I have access and sql logging in with the windows administrator. why would it make a difference if I was running this in front page, this is how I am designing the web site. Thank you Dee "Dee" wrote: This is what is in the calendar_script.asp string with line 35 objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#8
|
|||
|
|||
Error trying to connect to Access Database
Yes, I am the administrator. I am building a web site on my computer using
frontpage 2003. Does that have anything to do with it. I am using the windows admin userid and password. Thanks Dee "Douglas J. Steele" wrote: I suspect strSQL is an Action query (INSERT INTO, UPDATE or DELETE) and that your database isn't updatable because of the permissions issue. Are you the administrator of the server where the ASP is running? If not, ask the administrator to check the permission for you. Otherwise, select the folder in Windows Explorer, right-click and select Properties, then look on the Security tab. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message news This is what is in the calendar_script.asp string with line 35 objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#9
|
|||
|
|||
Error trying to connect to Access Database
Did you try what I suggested?
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... Yes, I am the administrator. I am building a web site on my computer using frontpage 2003. Does that have anything to do with it. I am using the windows admin userid and password. Thanks Dee "Douglas J. Steele" wrote: I suspect strSQL is an Action query (INSERT INTO, UPDATE or DELETE) and that your database isn't updatable because of the permissions issue. Are you the administrator of the server where the ASP is running? If not, ask the administrator to check the permission for you. Otherwise, select the folder in Windows Explorer, right-click and select Properties, then look on the Security tab. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message news This is what is in the calendar_script.asp string with line 35 objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
#10
|
|||
|
|||
Error trying to connect to Access Database
I went to permissions and on the folder and I do not have a security tab. I
have general, quick find, sharing, web sharing and customize. I fixed it to for web sharing and still get the same error. Thanks Dee "Douglas J. Steele" wrote: Did you try what I suggested? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... Yes, I am the administrator. I am building a web site on my computer using frontpage 2003. Does that have anything to do with it. I am using the windows admin userid and password. Thanks Dee "Douglas J. Steele" wrote: I suspect strSQL is an Action query (INSERT INTO, UPDATE or DELETE) and that your database isn't updatable because of the permissions issue. Are you the administrator of the server where the ASP is running? If not, ask the administrator to check the permission for you. Otherwise, select the folder in Windows Explorer, right-click and select Properties, then look on the Security tab. -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message news This is what is in the calendar_script.asp string with line 35 objConn.Execute(strSQL) Set objRS = Nothing objConn.Close Set objConn = Nothing I do not know how to check IUSR_machinename. The directory, folders, etc., I took the read only off. How do you set that for RWXD. I know how to do this lin Unix and Linux, but not in windows. Thanks Dee "Douglas J. Steele" wrote: Without knowing what line 35 in updateCalendar_script.asp is, it's pretty hard to suggest anything. Does the application work otherwise? Are you able to apply any updates to the database? If not, does the security context running the ASP page (usually IUSR_machinename) have the necessary permissions (RWXD) on the folder where the MDB file is located? -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Dee" wrote in message ... I am getting the following error when trying to connect to my access database: Technical Information (for support personnel) Error Type: Microsoft JET Database Engine (0x80004005) Operation must use an updateable query. /saveyonce/calendar/updateCalendar_script.asp, line 35 Browser Type: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; .NET CLR 2.0.50727; InfoPath.1) Page: POST 62 bytes to /saveyonce/calendar/updateCalendar_script.asp POST Data: calendarText=Darlene+-+color+10%3A00¤tDate=10%2F7%2F2006 Time: Saturday, October 07, 2006, 1:14:27 PM More information: Microsoft Support I am running windows xp sp2, Office 2003. I have down loaded all updates for windows and office, made sure the folders are not read only. made sure the database is 2002-2003, went to %systemroot%:\Program Files\Common Files\System\Ole db and typed regsvr32 sqloledb.dll. I do not know what else to do, and I am trying to get a web site done. Also I am using frontpage 2003, why is it my .asp files do not run in any other browser. When creating a web site I test the most important browsers. In this case it wants to open or save the file. Thank you Dee |
|
Thread Tools | |
Display Modes | |
|
|