Results 1 to 5 of 5

Thread: How to handle run time error 3110

  1. #1

    Thread Starter
    New Member
    Join Date
    Oct 2014
    Location
    India
    Posts
    2

    Question How to handle run time error 3110

    I have developed an application in vb6 and for database using MsAccess 97.
    Some table not having permission for access. That time I am facing run time error 3110 “ couldn’t read definition, no read definition permission for table or query “Employee”.
    How to check and set the permissions in vb6.


    Please i need urgent help on this.
    Last edited by Kunal Ambastha; Dec 16th, 2014 at 01:16 AM.

  2. #2
    PowerPoster SamOscarBrown's Avatar
    Join Date
    Aug 2012
    Location
    NC, USA
    Posts
    9,145

    Re: How to handle run time error 3110

    Coe where you get the error please...... Where (in what path) is your DB located? Can you open the table/db by going through Access manually?

  3. #3
    PowerPoster
    Join Date
    Feb 2012
    Location
    West Virginia
    Posts
    14,205

    Re: How to handle run time error 3110

    One would think that if it was really "Urgent" you would have posted some code and details as to where the error occurred.
    Since we have no code to go on there is not much we can do to help other than to tell you to check the file permissions and check your code for errors.

  4. #4
    Addicted Member Wolfgang Enzinger's Avatar
    Join Date
    Apr 2014
    Location
    Munich, Germany
    Posts
    160

    Re: How to handle run time error 3110

    Quote Originally Posted by Kunal Ambastha View Post
    I have developed an application in vb6 and for database using MsAccess 97.
    Some table not having permission for access. That time I am facing run time error 3110 “ couldn’t read definition, no read definition permission for table or query “Employee”.

    http://office.microsoft.com/en-us/ac...in=HV080756967

    "You must have read definitions permission for the specified table or query to read its definition. To change your permission assignments, see your system administrator or the table or query's creator."

    Wolfgang

  5. #5

    Thread Starter
    New Member
    Join Date
    Oct 2014
    Location
    India
    Posts
    2

    Re: How to handle run time error 3110

    Quote Originally Posted by DataMiser View Post
    One would think that if it was really "Urgent" you would have posted some code and details as to where the error occurred.
    Since we have no code to go on there is not much we can do to help other than to tell you to check the file permissions and check your code for errors.
    'code is... for deleteing the query
    Public Sub DeleteQuery()
    strName="Employee" ' query name
    Dim qdfLoop As QueryDef
    Dim strSQL As String
    For Each qdfLoop In dbAny.QueryDefs
    If UCase$(qdfLoop.name) = UCase$(strName) Then
    strSQL = qdfLoop.sql
    dbAny.QueryDefs.Delete qdfLoop.name
    Exit For
    End If
    Next qdfLoop
    End Sub

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width