Access security

  • Thread starter Thread starter Chris
  • Start date Start date
C

Chris

Hello,

I have an app that connects to a 3rd pary access 2000 database. I am able
to open the connection but when I query a table, I get the message :

Record(s) cannot be read; no read permission on 'table'

where 'table' is the name of the table I am querying.

My app works fine on my development machine and any machine with access
installed. There is no MDW file anywhere on the target system (Win 98) and
the third party app works perfectly on the target system. The database has
no user passwords.

Can anyone suggest a possible fix for my problem?

Regards,

Chris
 
Personally, I'd be checking whether the 3rd party app uses a workgroup
file with a non-standard extension. For example, you could name your
workgroup file "fred.smith", if you wanted to!

IOW, the absence of an MDW file, does /not/ necessarily mean that the
app is not using a workgroup file.

HTH,
TC
 
Further to that, when the app is running, the workgroup file will be
opened. Accordingly, there should be an .LDB file created in the same
folder as the workgroup file. AFAIK, it is impossible to alter the
extension of the .LDB file. So if you can find an LDB file when the
app is running, you should have also found the workgroup file.



Personally, I'd be checking whether the 3rd party app uses a workgroup
file with a non-standard extension. For example, you could name your
workgroup file "fred.smith", if you wanted to!

IOW, the absence of an MDW file, does /not/ necessarily mean that the
app is not using a workgroup file.

HTH,
TC
Click to expand...


**********************
(e-mail address removed)
remove uppercase letters for true email
http://www.geocities.com/jacksonmacd/ for info on MS Access security
 
Nice one! I thought briefly of how he could test for an open workgroup
file, but I did not think of that.

Cheers,
TC
 
Thanks for all the help. It is much appreciated. I hadnt thought of that
one either.

Cheers,

Chris
 
Back
Top