INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

New database failure 7011:Insufficient access right for the operation

New database failure 7011:Insufficient access right for the operation

New database failure 7011:Insufficient access right for the operation

(OP)
I am getting the same error "New database failure 7011:Insufficient access right for the operation" in the following environment:

1. Windows 8.1 Pro
2. Pervasive.SQL 10.3 Workgroup
3. Standalone PC

I have run a registry cleaner application, uninstalled and re-installed Pervasive. I have given full read/write access to the Pervasive Software folder. pcc.exe is set to run as administrator in the compatibility settings

Somebody help please

RE: New database failure 7011:Insufficient access right for the operation

What about the engine itself? Are you running it as a service or as a regular process?
Does the logged in user have rights to the "C:\Pastel12\Bill" folder?
Does that folder exist?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: New database failure 7011:Insufficient access right for the operation

(OP)
I installed Pervasive v10.3 and of the two options
1. Application
2. Service

I installed pervasive as an application. The folder exists and user has full rights to c:\Pastel12\Bill
I have been able to create dsn in pcc but all of a sudden I start having access issues

RE: New database failure 7011:Insufficient access right for the operation

So it was working but now is returning the 7011? Did anything get updated (Pervasive, Pastel,etc) when it stopped working? Can you post the PVSW.LOG file?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: New database failure 7011:Insufficient access right for the operation

As far as I know, Pervasive does not self update.
Can you create a database pointing to another directory? Does that work or return the 7011 as well?

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

RE: New database failure 7011:Insufficient access right for the operation

(OP)
A different Database works. I repeated my sequence of event and got same error as before. On initially creating the database I have

On Database Options
Bound [no tick]
Create dictionary files [tick]
Relational Integrity Enforced [tick]

When I save and go back to the database properties and try to put a tick on BOUND to save then I get the error

RE: New database failure 7011:Insufficient access right for the operation

Do DDFs already exist in the C:\Pastel12\Bill folder? If so, uncheck the Bound option. The Bound option binds the DDFs and data files together and writes the Database Name inside both Data files and DDFs. This is helpful in some cases but will cause an error if the database is moved (or copied).
Unchecking the Bound option won't affect normal usage and is the standard mode.

Mirtheil
Certified Pervasive Developer
Certified Pervasive Technician
http://www.mirtheil.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close