No Read Permission Error - Reading MSysErrors - Replication 3

[sathandle]

I am receiving a "No Read Permission Error" (Error # 3112) which states:

Run-time error '3112':
Record(s) can't be read; no read permission on 'tablename'

OS: NT 4.0 Access ver. 97 Workgroup Information File: Default (no changes to security model)

Any ideas? I am trying to read MSysErrors (Synchronization Errors Data Table) from another separate database. I am using DAO.

Dim db as Database
Dim rst as Recordset

Set db = OpenDatabase(DBNAME()) ' works fine
Set rst = OpenRecordset("MSysErrors&quot ' error generated here

Any suggestions?

Thanks,
SATHandle

definition of 'less behind': "not fully caught up, digging out slowly, one-week delay to "The IT hit the fan."

 

[downwitchyobadself]

Just a guess, but I'm not sure that MSys appears in a normal table collection. Try this instead:

Set rst = OpenRecordset(db.TableDefs("MSysErrors&quot)

 

[downwitchyobadself]

Sorry, I don't know what I was thinking. I meant this:

db.TableDefs("MSysErrors&quot.OpenRecordset

 

[sathandle]

A modified solution from the Microsoft Knowledge Base Article #236878 was my resolution.

I added the following line of code before I open the external database:

DBEngine.SystemDB = "C:\Windows\System\system.mdw"

and everything seems (I use this losely) to work fine.

Downwithyobadself - Thanks for your insight. I didn't know I could open a database/recordset in that manner. I had learned a different method.

Thanks
SATHandle definition of 'less behind': "not fully caught up, digging out slowly, one-week delay to "The IT hit the fan."

 

[jbpelletier]

I had same problem:|
tanx for the solution to your own thread!

jb