Snitz Forums 2000
Snitz Forums 2000
Home | Profile | Register | Active Topics | Members | Search | FAQ
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 Help Groups for Snitz Forums 2000 Users
 Help: Database: MS Access
 Cannot open accesss database error
 New Topic  Topic Locked
 Printer Friendly
Previous Page
Author Previous Topic Topic Next Topic
Page: of 4

chiefcook
Starting Member

USA
30 Posts

Posted - 09 August 2006 :  12:20:07  Show Profile
Yeah, I am hosting this in-house. I'll do some more research on Windows 2003 and ASP. Thanks for everything. I will Post when I find an answer from this end.

Everything is easier when it is someone else's responsibility
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 09 August 2006 :  14:39:25  Show Profile
I altered setup.asp in order to try placing the DB in a different directory outside of the web root and I now get this error.

Does this seem a little more "normal" for an error?

Server object error 'ASP 0178 : 80070005'

Server.CreateObject Access Error

/forum/inc_header.asp, line 110

The call to Server.CreateObject failed while checking permissions. Access is denied to this object.

I jsut wanted to see if the permissions might have been screwy on the web root, so I redid my web from scratch and decided to relocate the DB... unhappy users for a while <grin>

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 09 August 2006 :  15:50:51  Show Profile  Send ruirib a Yahoo! Message
It's the same kind of error, with what it seems to be a different message. The error still occurs while creating a connection object, which seems weird, I never saw it before. I must admit that my experience with Windows 2003 is quite limited, though. It's a permissions error, nonetheless.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 09 August 2006 :  16:35:13  Show Profile
I did some further research about ASP and windows 2003 and it seems that there are alot of others with this type of issue. Unfortunately, none of their resolutions seem to help. I'll with post if I find anything. Thanks for taking the time to help from the software end.

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 09 August 2006 :  17:14:40  Show Profile  Send ruirib a Yahoo! Message
Really? It's the first time it appears here... Do you have Windows 2003 up to date?


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 10 August 2006 :  06:04:55  Show Profile
I don't have a sandbox to test security patches so they go on this production server within 10 days or so of release.

A lot of the issues seem to revolve around service pack 1. Here is a relative link http://bugs.mysql.com/bug.php?id=9932 It is from 2005...

I have to keep service pack 1. I may be able to throw the forum on a 2k or XP machine if I cannot resolve on 2003

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 10 August 2006 :  07:31:24  Show Profile  Send ruirib a Yahoo! Message
Maybe you should try Win2k server... XP will only allow you 10 simulataneous connections.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 15 August 2006 :  06:02:48  Show Profile
I'll try it. Thanks for the help!

Everything is easier when it is someone else's responsibility
Go to Top of Page

chiefcook
Starting Member

USA
30 Posts

Posted - 16 August 2006 :  08:46:22  Show Profile
Hey Ruirib! I found the answer!!!! It is in this knowledgebase article KB 315454. I have included the link http://support.microsoft.com/kb/315454. This completely fixed this issue. Now, hopefully I can get the email portion up <GRIN>

Everything is easier when it is someone else's responsibility
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 16 August 2006 :  09:38:52  Show Profile  Send ruirib a Yahoo! Message
Cool . Glad you found it.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

RobincMBA
Starting Member

Canada
2 Posts

Posted - 25 August 2006 :  17:19:12  Show Profile  Visit RobincMBA's Homepage
I'm running Windows XP Media Center 2005 with IIS 5.1; no matter what option I select for accessing an MS Access database, when I click on the link to initialize the database, I keep getting 13 Critical errors, all the same: "Error: -2147467259" which is described as "Operation must use an updatable query," even though the details, clearly the queries listed are correct.

I have both MS Access 2000 and MS Access 2003 installed; I have tried using a system DSN, as well as the directory path options in config.asp

Has anyone experienced this? If so, is there something I'm missing?

Thanks for your help in the matter.


Sincerely,

Robin L. M. Cheung, BScH, MBA

RobinCheung@rogers.com
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 August 2006 :  17:35:47  Show Profile  Send ruirib a Yahoo! Message
If you try a search using 'updateable query' as the keywords, you will find that the same issue has occurred with a lot of users before. It's a permissions error, you need to assign read / write permissions on the database file and folder, for the anonymous internet user (IUSR_YourComputerName).

Also, you should have started a new topic.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page

RobincMBA
Starting Member

Canada
2 Posts

Posted - 25 August 2006 :  17:44:39  Show Profile  Visit RobincMBA's Homepage
Sorry for not starting a new topic; however, I noticed that one difference between XP Pro and XP Media Center (although both use IIS 5.1 I believe), is that the Security and Sharing tabs are not the same; whereas in XP Pro you could select Security | Advanced and add specific users permissions, I cannot locate the same functionality in XP Media Center.

I had suspected it was a permissions issue, but I do not know how to set permissions for specific users in XP Media Center, if there is a workaround, or if it is hidden somewhere else.

Thanks for the prompt reply

Sincerely,

Robin L. M. Cheung, BScH, MBA

RobinCheung@rogers.com
Go to Top of Page

ruirib
Snitz Forums Admin

Portugal
26364 Posts

Posted - 25 August 2006 :  18:34:12  Show Profile  Send ruirib a Yahoo! Message
See if you can turn of the option to Use Simple File Sharing in Tools->Options, View tab, in Windows Explorer.


Snitz 3.4 Readme | Like the support? Support Snitz too
Go to Top of Page
Page: of 4 Previous Topic Topic Next Topic  
Previous Page
 New Topic  Topic Locked
 Printer Friendly
Jump To:
Snitz Forums 2000 © 2000-2021 Snitz™ Communications Go To Top Of Page
This page was generated in 0.62 seconds. Powered By: Snitz Forums 2000 Version 3.4.07