Solved

VB - Access - No Read permission on Data Field

Posted on 1998-04-09
5
162 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

Question has a verified solution.

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

Suggested Solutions

I’ve seen a number of people looking for examples of how to access web services from VB6.  I’ve been using a test harness I built in VB6 (using many resources I found online) that I use for small projects to work out how to communicate with web serv…
The debugging module of the VB 6 IDE can be accessed by way of the Debug menu item. That menu item can normally be found in the IDE's main menu line as shown in this picture.   There is also a companion Debug Toolbar that looks like the followin…
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 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…

759 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