Solved

Visio2000 cannot extract column definition for access97 with security

Posted on 2002-05-16
7
468 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
Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

 

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
filter options in excel 2013 or 2016 3 42
How to configure smtp service for Sharepoint server? 4 61
Copying and pasting pictures from Excel 2 46
MS Office subscription 11 51
Introduction It seems that at least a couple of times per month, I answer a question that requires automating Outlook from another Microsoft Office application, usually (although not always) to send one or more email messages.  For example: …
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.
This video shows where to find the word count, how to display it, and what it breaks down to in Microsoft Word.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…

813 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

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now