Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

VB - Access - No Read permission on Data Field

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

I was working on a PowerPoint add-in the other day and a client asked me "can you implement a feature which processes a chart when it's pasted into a slide from another deck?". It got me wondering how to hook into built-in ribbon events in Office.
Since upgrading to Office 2013 or higher installing the Smart Indenter addin will fail. This article will explain how to install it so it will work regardless of the Office version installed.
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…
Suggested Courses

688 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