Re: Error trying to connect to Access Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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" <Dee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:1533B5F3-4BCE-4C09-B22B-DEFA1AD5E542@xxxxxxxxxxxxxxxx
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" <Dee@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D1DDB559-41E5-422C-87E8-8E3808761970@xxxxxxxxxxxxxxxx
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: Setting folder permission questions
    ... The web sharing folder permissions are the same as those defined for ... Sharing permissions are for other network ... Be sure to check out the IIS ...
    (microsoft.public.win2000.security)
  • Re: CGI. postgres local install, DBD::Pg fails
    ... via web sharing. ... installed in the local (admin) folder instead of /usr/local. ... a manual fix of permissions did the trick.. ...
    (comp.lang.perl.misc)
  • Re: Minimum NTFS Permissions - Theres such a thing???
    ... ?2001 Microsoft Corporation. ... HOW TO: Set Minimum NTFS Permissions Required for IIS 5.0 to Work WGID:198 ... " List Folder Contents" ...
    (microsoft.public.inetserver.iis.security)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The fact that the tech support is based in India has nothing to do with the ... If so you may want to leave this folder alone. ... down to all children folders because i can set those permissions to ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Unable to delete orphaned 1.5 GB System Restore folder
    ... The only computers i fix are my own. ... If so you may want to leave this folder alone. ... it includes all subdirectories with inherited permissions. ... try deleting from the command line using system by using the AT ...
    (microsoft.public.windowsxp.security_admin)