HELP! -VB4 and Querydef - runtime error 3110 
Author Message
 HELP! -VB4 and Querydef - runtime error 3110

   I'm recieving the following error when trying to set and do stored SQL
query.

  Runtime 3110
  Couldn't read definitions; no Read Design permissions for table or query
'mSysQueries'

   I don't know what the mSysQueries refers to.

   Any help will be appreciated.

   Thanks, John

---------------------------------------------------------
Code:
Private Sub IndexStrip_Click()

Dim Qd As QueryDef, Rs As Recordset
Dim SQL As String

SQL = "SELECT * From Members WHERE LastName Like 'C*';"

Set Qd = MDTDataBase.Database.CreateQueryDef("MyQuery")
Set Qd = MDTDataBase.Database.QueryDefs("MyQuery")

'Create a new Recordset from the Query based on the stored QueryDef.

Set Rs = Qd.OpenRecordset(Qd, dbOpenDynaset)

'Pass the Recordset back to the Data control.

Set MDTDataBase.Recordset = Rs

End Sub
----
John P. Cox



Wed, 27 May 1998 03:00:00 GMT  
 
 [ 1 post ] 

 Relevant Pages 

1. Error 3110 with QueryDefs in Access 1.10 with VB4

2. Error 3110 - need help reading QueryDefs

3. Error 3110 Read Design

4. HELP! - VB 4 runtime error with Querydef

5. HELP: Opening Access QueryDef with an embedded function via VB4

6. VB4 Jet Engine Runtime Error 3196

7. VB4: runtime error 3426

8. Help with Error on test program - Runtime Error 10048

9. VB4 Setup Wrong Version Runtime DLL error

10. Setup gets WRONG RUNTIME DLL error VB4

11. VB4 32bit Runtime Errors

12. A very strange runtime error - only happens inside VB4 debugger , not with .exe

 

 
Powered by phpBB® Forum Software