Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

VB - Access - No Read permission on Data Field

Posted on 1998-04-09
5
Medium Priority
?
165 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 150 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

Important Lessons on Recovering from Petya

In their most recent webinar, Skyport Systems explores ways to isolate and protect critical databases to keep the core of your company safe from harm.

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…
Most everyone who has done any programming in VB6 knows that you can do something in code like Debug.Print MyVar and that when the program runs from the IDE, the value of MyVar will be displayed in the Immediate Window. Less well known is Debug.Asse…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…
Suggested Courses

824 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