Re: Error trying to connect to Access Database

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

I have done what Douglas has stated, but I do not have a security tab when I
click on the
properties tab. I am also reading from the link you sent me. How do I get
this to run outside of front page, it needs to be in the inetpub directory.
when I try to run this in netscape it want to open the .asp file or save it.

Thanks
Dee

"Wayne-I-M" wrote:

Hi Dee

Douglas has given you a few ideas - have you tried them. Also look at the
site and see if any of the items refer to your DB.
http://www.webwizguide.com/asp/faq/access_database_faq.asp

why would it make a difference if I was running this in front page, this is
how I am designing the web site.
If you are designing a DB to use in a frontpage web you should seign the DB
"then" include it into the web. You may find it difficult to get into the DB
from Frontpage as you need to be running access to get into an Access DB with
the corect permissions.



--
Wayne
Manchester, England.
Enjoy whatever it is you do


"Dee" wrote:

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" <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: Error trying to connect to Access Database
    ... windows admin userid and password. ... your database isn't updatable because of the permissions issue. ... Are you the administrator of the server where the ASP is running? ... I do not know what else to do, and I am trying to get a web site done. ...
    (microsoft.public.access.gettingstarted)
  • Re: Error trying to connect to Access Database
    ... I am building a web site on my local machine. ... I have access and sql logging in with the windows administrator. ... the database? ...
    (microsoft.public.access.gettingstarted)
  • Re: Error trying to connect to Access Database
    ... I am not trying to get into the database from ... Create the page that will access the db in frontpage ... how I am designing the web site. ... I have access and sql logging in with the windows administrator. ...
    (microsoft.public.access.gettingstarted)
  • Re: Error trying to connect to Access Database
    ... Douglas has given you a few ideas - have you tried them. ... how I am designing the web site. ... I have access and sql logging in with the windows administrator. ... the database? ...
    (microsoft.public.access.gettingstarted)
  • [NT] Vulnerability in HTML Help Allows Code Execution (MS05-001)
    ... The following security advisory is sent to the securiteam mailing list, and can be found at the SecuriTeam web site: http://www.securiteam.com ... Get your security news from a reliable source. ... * Microsoft Windows XP Service Pack 1 and Microsoft Windows XP Service ...
    (Securiteam)