Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Software > Access Modules daovba ado > Run-time error ...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 5 Topic 1497 of 1609
Post > Topic >>

Run-time error '3112' Record(s) cannot be read; no read permission

by =?Utf-8?B?aGxhbW8=?= <hlamo@[EMAIL PROTECTED] > Jun 18, 2008 at 10:51 AM

I have an Access 2003 FE & BE database running on a PC. The source for a 
Combo box is a simple query that selects all 6 fields from a Sales Source 
linked table. I have an After Update Event which checks the OldValue from
the 
Combo Box to see if it is a particular type of sales source, as it uses
the 
information to update counters. 
When a user selects a different value in the Combo Box and so triggers off

the After Update event, I get the 3112 error on the OpenRecordset
statement. 
Can anyone offer advice, please? Is there a conflict between the query and

the statement?
 
Coding in the after-update event calls a function that contains the 
following: 

Function GetSalesSource(SalesSourceId As Long) As String

    Dim db2 As DAO.Database
    Dim rst2 As DAO.Recordset
    Dim pathname2 As String
    Dim dblocation2 As String
        
    pathname2 = Application.CurrentProject.Path
    dblocation2 = pathname2 & "\Tables\system tables.mdb"
           
    GetSalesSource = "N"
    Set db2 = OpenDatabase(dblocation2)
    Set rst2 = db2.OpenRecordset("Sales Source")
    
    rst2.Index = "SSrc_Id"
    rst2.Seek "=", SalesSourceId
    If rst2!SSrc_Description = "Repair Only" Then
        GetSalesSource = "Y"
    End If
    
    rst2.Close
    db2.Close
   
        
End Function
 




 5 Posts in Topic:
Run-time error '3112' Record(s) cannot be read; no read permissi
=?Utf-8?B?aGxhbW8=?= <  2008-06-18 10:51:08 
RE: Run-time error '3112' Record(s) cannot be read; no read perm
=?Utf-8?B?UnVp?= <Rui@  2008-06-19 02:00:01 
RE: Run-time error '3112' Record(s) cannot be read; no read perm
=?Utf-8?B?aGxhbW8=?= <  2008-06-19 04:06:49 
RE: Run-time error '3112' Record(s) cannot be read; no read perm
=?Utf-8?B?aGxhbW8=?= <  2008-06-19 04:18:01 
RE: Run-time error '3112' Record(s) cannot be read; no read perm
=?Utf-8?B?UnVp?= <Rui@  2008-06-19 05:46:06 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Fri Nov 21 11:27:19 CST 2008.