Solved

VB - Access - No Read permission on Data Field

Posted on 1998-04-09
5
159 Views
Last Modified: 2006-11-17
I can open the database in Access and view,change,and design it, but in VB I get the "No read permission" msg box when I try to assign a text box a data field.  The record source in the Data control can see the tables but it yaks when I try to access a field in a record.  I feel like such a loser.  Any answers.  I have not set any permissions in access.  Both are fresh installs.
0
Comment
Question by:DVanMeter
  • 2
  • 2
5 Comments
 
LVL 2

Expert Comment

by:woka
ID: 1460863
Are you using JOIN's in your SQL statement ?  Some joins will create a read-only recordset if you have a one-to-many relationship.
0
 
LVL 2

Accepted Solution

by:
lortega earned 50 total points
ID: 1460864
Your DAO object have AllPermissions property already set, so...

First: print the current AllPermissions in the debug window... you can have reference in help with 'AllPermissions' word... be sure to have dbSecReadDef in the property...

Second: maybe you have your DBEngine configured to load some system-security database "system.mdw", you can verify this using Regedit tool (in your windows directory) and check for
My Computer\HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet here you can have information about your configuration...

Third: if you have this problem just in this table, try to use some utility to crack your database from security services... you can check one in www.easytools.com, they have some good tool in shareware version

0
 

Author Comment

by:DVanMeter
ID: 1460865
This is what comes out for the database

Container: Databases
User: admin
    Permissions: 0
    AllPermissions: 0
Container: Tables
User: admin
    Permissions: 0
    AllPermissions: 1048575

Now I have to Set them, somehow.
0
 
LVL 2

Expert Comment

by:lortega
ID: 1460866
if you can get values is because you have your dbengine attached to a workgroup file, is not that you make an attachment in this proyect, is posible that you use Acccess and Acccess doit for you...


how to verify... simply, just print SystemDb property

Debug.Print DBEngine.SystemDB

how to changed... simply change the property after use any database...

DBEngine.SystemDB = ""

'*******************************************
Notes:

a. is important that you verify your registry with Regedit, so you dont have to set the property in your next proyects.

b. if your database was created in other computer... verify if this computer dont use an workgroup file.
0
 

Author Comment

by:DVanMeter
ID: 1460867
Access was the culprit.  I had tried it before but must have done it wrong. I used Access  to give permissions.  Thanks
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http://www.experts-exchange.com/Q_27402310.html) in the VB classic zone, I wrote some VB code in the (Office) VBA environment, rather than fire up my older PC.  I didn't post completely correct code o…
If you need to start windows update installation remotely or as a scheduled task you will find this very helpful.
Get people started with the process of using Access VBA to control Outlook using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Microsoft Outlook. Using automation, an Access applic…
Get people started with the process of using Access VBA to control Excel using automation, Microsoft Access can control other applications. An example is the ability to programmatically talk to Excel. Using automation, an Access application can laun…

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question