Re: 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" <Dee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:8600F414-47C9-4384-8E00-EA74ACA4983F@xxxxxxxxxxxxxxxx
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&currentDate=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



.

Relevant Pages

  • Re: Removing Uninstall files
    ... Removing Old Windows Updates:- ... Folders that have uninstall as part of the name (for example $NtUninstallKB282010$ which ... safely deleted (providing you never wish to uninstall the updates). ... These updates can be deleted individually or in multiples. ...
    (microsoft.public.windowsxp.perform_maintain)
  • RE: reclaiming space on C:? Move SPuninst?
    ... These folders contain the uninstallation files for these Windows ... backup Exchange information store, you can refer to the following Microsoft ... the size of the database will keep the same ...
    (microsoft.public.windows.server.sbs)
  • RE: uninstall packages
    ... These folders contain the uninstallation files for these Windows ... backup Exchange information store, you can refer to the following Microsoft ... the size of the database will keep the same ...
    (microsoft.public.windows.server.sbs)
  • Re: reclaiming space on C:? Move SPuninst?
    ... These folders contain the uninstallation files for these Windows ... > replaced by the updates and service pack. ... Perform an online backup of the Exchange Information Store to purge ...
    (microsoft.public.windows.server.sbs)
  • Re: how to move location of default database???? plz!
    ... fine, cool about the database, it probably amounts to how much tagging one ... updates - i woulda rolled them all back. ... No recent version of Windows does ... well when you have less than about 50MB to 100MB of free space. ...
    (microsoft.public.windowsmedia.player)
Loading