record(s) cannot be read: no read permission

G

Garret Hurd

I am trying to read the records an access2k database from and ADO procedure
inside another Acess2k database. I get an record(s) cannot be read: no read
permission error. I am not sure what identfies me as a user or how the other
database is determining security levels. I am not prompted for login name. I
do have several network privileges. Any guidance is suggested.

here is my code
Public Function GetDR(PartNumber As String) As String

Dim MyDb As Database
Dim RS2 As Recordset
Set MyDb = CurrentDb
Set RS2 = New ADODB.Recordset
RS2.Open "Select * From tblparts Where (partnumber = '" & PartNumber & "')",
_
"Provider=Microsoft.Jet.OLEDB.4.0;Data source=l:\database\dr database\back
end\DrDataBeta V1_be.mdb", adOpenStatic
RS.MoveLast
MsgBox RS2.RecordCount

End Function
 
J

JohnFol

Go into Tools\Security\User group permissions
By default you will probably be a user called Admin and are in the Users
group.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Drop Down doesn't populate form 0
Record(s) cannot be read; no read permission on 'MSysAccessStorage 1
Run-time error '3112' Record(s) cannot be read; no read permission 4
No Read Permission Error 4
Dim rs As DAO.Recordset Error 1
Error - Record(s) can't be read, no read permissions on 0
No value given for one or more required parameters 2
Event procedure not working 2

Top