Solved

Visio2000 cannot extract column definition for access97 with security

Posted on 2002-05-16
7
469 Views
Last Modified: 2008-02-26
I have an Access97 "database" with security on all objects.  Admin (the default) is disabled.  When I try to reverse engineer a database diagram in Visio2000 for it I get this error on every table and query: "Error! Cannot extract column definition for the table/view [x].  The definition is not available or you may not have sufficient privileges.  Please check with your database administrator."  Yet I am joined to a group that has all priviledges.  Are there some hidden settings for dealing with Access security from Visio?
0
Comment
Question by:keyboards
  • 5
7 Comments
 
LVL 44

Expert Comment

by:bruintje
ID: 7135489
Hi keyboards,

maybe a workaround, couldn't find more at the moment

is to get all security of the access db, maybe on a copy just for this purpose, don't know if it's possible

:O)Bruintje
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7214988
any update here? can we get closing recoms?
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7225419
Hello keyboards

this question is open for more then 2 months
time to clean up
if not stated otherwise

my recom will be
-Delete and refund
-this will be finalized by an EE Moderator
-with no further update (23.08.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:keyboards
ID: 7225659
The suggestion was a good one (cause it occurred to me as well ;0} ) however, it did not work.  It almost makes me suspect inherent problems between Access97 and Visio2000, which suggests another "workaround", bringing the DB into Access2000 and trying again.

I appologise for the delay in acknowleging; it's been crazy around here.

Hope there are other suggestions, but I'll update this on the outcome of the above test.

Thanks!
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7249985
Hello keyboards ,would be great to know what comes out of it. :O)Bruintje
0
 
LVL 44

Expert Comment

by:bruintje
ID: 7400508
Hello keyboards

this question is open for more then 2 months
time to clean up
if not stated otherwise

my recom will be
-PAQ and no refund
-this will be finalized by an EE Moderator
-with no further update (09.11.2002)

PLEASE DO NOT ACCEPT THIS COMMENT AS ANSWER

HAGD:O)Bruintje
posted by ToolzEE v1.0
0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 7428335
PAQ'd and points removed as proposed

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

In this article we discuss how to recover the missing Outlook 2011 for Mac data like Emails and Contacts manually.
This article descibes how to create a connection between Excel and SAP and how to move data from Excel to SAP or the other way around.
The viewer will learn how to simulate a series of coin tosses with the rand() function and learn how to make these “tosses” depend on a predetermined probability. Flipping Coins in Excel: Enter =RAND() into cell A2: Recalculate the random variable…
The viewer will learn how to use the =DISCRINV command to create a discrete random variable, use this command to model a set of probabilities and outcomes in a Monte Carlo simulation, and learn how to find the standard deviation of a set of probabil…

830 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