HP3000-L Archives

November 2001, Week 1

HP3000-L@RAVEN.UTC.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Burgess Peter <[log in to unmask]>
Reply To:
Burgess Peter <[log in to unmask]>
Date:
Fri, 2 Nov 2001 17:13:30 -0000
Content-Type:
text/plain
Parts/Attachments:
text/plain (121 lines)
We have Omnidex on the db but I doubt if this is causing any issues.

Regards

Peter

-----Original Message-----
From: TRAPP,RICH (Non-A-Loveland,ex1)
[mailto:[log in to unmask]]
Sent: 02 November 2001 16:59
To: 'Burgess Peter'; TRAPP,RICH (Non-A-Loveland,ex1);
[log in to unmask]
Subject: RE: Database Aoptions errors


Peter,
   Is the database attached to an Allbase DBE file? Is there a dbnameTC
file?  Any Third Party Indexes? How about Image Index files? (I'm fishing
;-) ). I've never seen this with %000000 for the Aoptions
requested...something's strange it happening.

Rich

   

Rich Trapp <mailto:[log in to unmask]>  

Consulting for Agilent Technologies, Loveland, Colorado.

Managed Business Solutions <http://www.mbsnav.com/>  
200 South College Avenue 
Fort Collins, Colorado 80524-2811 
970.679.2221 (voice) 
970.669.3071 (fax) 



-----Original Message-----
From: Burgess Peter [mailto:[log in to unmask]]
Sent: Friday, November 02, 2001 9:56 AM
To: 'TRAPP,RICH (Non-A-Loveland,ex1)'; [log in to unmask]
Subject: RE: Database Aoptions errors



Hi Richard

I tried this before and the access writes are for set for 'any' on account
group and file and there are no acds. I have also released the db as well in
dbutil and mpex.

Regards

Peter
-----Original Message-----
From: TRAPP,RICH (Non-A-Loveland,ex1)
[mailto:[log in to unmask]]
Sent: 02 November 2001 16:53
To: 'Burgess Peter'; [log in to unmask]
Subject: RE: Database Aoptions errors


Peter,
  Typically this means that the actual MPE file access security is not
allowing WRITE access to the physical database files.

   You should try doing a :LISTF dbname,4 and it will show you the access
you're allowed.  Usually it's a group or account not allowing READ:ANY
causing the issue. Since this is a database, the typical (not personally
recommended fix) is the release the database inside DBUTIL.

Rich

   

Rich Trapp <mailto:[log in to unmask]>  

Consulting for Agilent Technologies, Loveland, Colorado.

Managed Business Solutions <http://www.mbsnav.com/>  
200 South College Avenue 
Fort Collins, Colorado 80524-2811 
970.679.2221 (voice) 
970.669.3071 (fax) 



-----Original Message-----
From: Burgess Peter [mailto:[log in to unmask]]
Sent: Friday, November 02, 2001 9:33 AM
To: [log in to unmask]
Subject: Database Aoptions errors
Importance: High


Hi

I am getting some confusing results when trying to access a database that
has been copied to a new account. If I use supertool or Query then I get the
following error message

base macbas.pub.frmacs,1,password

UNOBTAINABLE ACCESS MODE; AOPTIONS REQUESTED: %000000, GRANTED: %000000

If we try access using the database read password it works.

What is wrong with what we are doing , this is causing us some serious
issues.

Regards

Peter Burgess
www.microwarehouse.co.uk

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

ATOM RSS1 RSS2