Access denied


DevX Home    Today's Headlines   Articles Archive   Tip Bank   Forums   

Results 1 to 5 of 5

Thread: Access denied

Hybrid View

  1. #1
    Mike C. Guest

    Access denied


    I am using Windows 2000 Pro and Visual Studio 6.0. I set up a simple ASP page
    that connected to an Access database, did a simple select statement and displayed
    the results on the page. It worked fine for two weeks until today. Now it
    gives me a

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

    error, while trying to instantiate an ADODB.Recordset object. So I tried
    accessing the database directly from Visual Basic.. with pretty much the
    same result. So I tried the same thing on a different database.... same result.

    any ideas on why I cannot create an ADO recordset object?
    --Thanks
    MC

  2. #2
    Andres Silva Guest

    Re: Access denied


    you should verify the ntfs permissions on the database file.

    by the way did you lock the mdb file with a password? it could be another
    reason...

    "Mike C." <clinemi@gte.net> wrote:
    >
    >I am using Windows 2000 Pro and Visual Studio 6.0. I set up a simple ASP

    page
    >that connected to an Access database, did a simple select statement and

    displayed
    >the results on the page. It worked fine for two weeks until today. Now it
    >gives me a
    >
    >"Server.CreateObject failed while checking permissions. Access is denied
    >to this object."
    >
    >error, while trying to instantiate an ADODB.Recordset object. So I tried
    >accessing the database directly from Visual Basic.. with pretty much the
    >same result. So I tried the same thing on a different database.... same

    result.
    >
    >any ideas on why I cannot create an ADO recordset object?
    >--Thanks
    >MC



  3. #3
    Mike C. Guest

    Re: Access denied


    Thanks for the suggestion! Unfortunately, my computer will not allow me set
    file specific permissions, I believe because it was formatted using Fat instead
    of ntfs.

    Also, No I do not have any passwords associated with the databases I have
    been accessing. If you have any other ideas let me know. It just seems bizzare
    that the Recordset object would become "off-limits". I must have installed
    something that messed with the permissions.

    "Andres Silva" <asc@siesa.com> wrote:
    >
    >you should verify the ntfs permissions on the database file.
    >
    >by the way did you lock the mdb file with a password? it could be another
    >reason...
    >
    >"Mike C." <clinemi@gte.net> wrote:
    >>
    >>I am using Windows 2000 Pro and Visual Studio 6.0. I set up a simple ASP

    >page
    >>that connected to an Access database, did a simple select statement and

    >displayed
    >>the results on the page. It worked fine for two weeks until today. Now

    it
    >>gives me a
    >>
    >>"Server.CreateObject failed while checking permissions. Access is denied
    >>to this object."
    >>
    >>error, while trying to instantiate an ADODB.Recordset object. So I tried
    >>accessing the database directly from Visual Basic.. with pretty much the
    >>same result. So I tried the same thing on a different database.... same

    >result.
    >>
    >>any ideas on why I cannot create an ADO recordset object?
    >>--Thanks
    >>MC

    >



  4. #4
    Andres Silva Guest

    Re: Access denied


    are you using com+? are you using then transaction services? you might have
    not permissions to use the class.
    "Mike C." <clinemi@gte.net> wrote:
    >
    >Thanks for the suggestion! Unfortunately, my computer will not allow me

    set
    >file specific permissions, I believe because it was formatted using Fat

    instead
    >of ntfs.
    >
    >Also, No I do not have any passwords associated with the databases I have
    >been accessing. If you have any other ideas let me know. It just seems bizzare
    >that the Recordset object would become "off-limits". I must have installed
    >something that messed with the permissions.
    >
    >"Andres Silva" <asc@siesa.com> wrote:
    >>
    >>you should verify the ntfs permissions on the database file.
    >>
    >>by the way did you lock the mdb file with a password? it could be another
    >>reason...
    >>
    >>"Mike C." <clinemi@gte.net> wrote:
    >>>
    >>>I am using Windows 2000 Pro and Visual Studio 6.0. I set up a simple ASP

    >>page
    >>>that connected to an Access database, did a simple select statement and

    >>displayed
    >>>the results on the page. It worked fine for two weeks until today. Now

    >it
    >>>gives me a
    >>>
    >>>"Server.CreateObject failed while checking permissions. Access is denied
    >>>to this object."
    >>>
    >>>error, while trying to instantiate an ADODB.Recordset object. So I tried
    >>>accessing the database directly from Visual Basic.. with pretty much the
    >>>same result. So I tried the same thing on a different database.... same

    >>result.
    >>>
    >>>any ideas on why I cannot create an ADO recordset object?
    >>>--Thanks
    >>>MC

    >>

    >



  5. #5
    Mike C. Guest

    Re: Access denied


    That could be it. I am using a W2000 computer with com+ on it, although I
    am not using any com+ specific stuff. The only thing I've done with transactions
    is to set the properties of one of my projects to "Requires Transactions".
    I did do that recently, but why would that mess the permissions on ADO accessed
    through ASP? Any help would be appreciated.

    --thanks Mike C.

    "Andres Silva" <asc@siesa.com> wrote:
    >
    >are you using com+? are you using then transaction services? you might

    have
    >not permissions to use the class.
    >"Mike C." <clinemi@gte.net> wrote:
    >>
    >>Thanks for the suggestion! Unfortunately, my computer will not allow me

    >set
    >>file specific permissions, I believe because it was formatted using Fat

    >instead
    >>of ntfs.
    >>
    >>Also, No I do not have any passwords associated with the databases I have
    >>been accessing. If you have any other ideas let me know. It just seems

    bizzare
    >>that the Recordset object would become "off-limits". I must have installed
    >>something that messed with the permissions.
    >>
    >>"Andres Silva" <asc@siesa.com> wrote:
    >>>
    >>>you should verify the ntfs permissions on the database file.
    >>>
    >>>by the way did you lock the mdb file with a password? it could be another
    >>>reason...
    >>>
    >>>"Mike C." <clinemi@gte.net> wrote:
    >>>>
    >>>>I am using Windows 2000 Pro and Visual Studio 6.0. I set up a simple

    ASP
    >>>page
    >>>>that connected to an Access database, did a simple select statement and
    >>>displayed
    >>>>the results on the page. It worked fine for two weeks until today. Now

    >>it
    >>>>gives me a
    >>>>
    >>>>"Server.CreateObject failed while checking permissions. Access is denied
    >>>>to this object."
    >>>>
    >>>>error, while trying to instantiate an ADODB.Recordset object. So I tried
    >>>>accessing the database directly from Visual Basic.. with pretty much

    the
    >>>>same result. So I tried the same thing on a different database.... same
    >>>result.
    >>>>
    >>>>any ideas on why I cannot create an ADO recordset object?
    >>>>--Thanks
    >>>>MC
    >>>

    >>

    >



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
HTML5 Development Center
 
 
FAQ
Latest Articles
Java
.NET
XML
Database
Enterprise
Questions? Contact us.
C++
Web Development
Wireless
Latest Tips
Open Source


   Development Centers

   -- Android Development Center
   -- Cloud Development Project Center
   -- HTML5 Development Center
   -- Windows Mobile Development Center