Solved

Visio2000 cannot extract column definition for access97 with security

Posted on 2002-05-16
7
465 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
Comment Utility
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
Comment Utility
any update here? can we get closing recoms?
0
 
LVL 44

Expert Comment

by:bruintje
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 

Author Comment

by:keyboards
Comment Utility
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
Comment Utility
Hello keyboards ,would be great to know what comes out of it. :O)Bruintje
0
 
LVL 44

Expert Comment

by:bruintje
Comment Utility
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
Comment Utility
PAQ'd and points removed as proposed

modulo

Community Support Moderator
Experts Exchange
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Introduction Perhaps more familiar to developers who primarily use VBScript than to developers who tend to work only with Microsoft Office and Visual Basic for Applications (VBA), the Dictionary is a powerful and versatile class, and is useful …
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 use a discrete random variable to simulate the return on an investment over a period of years, create a Monte Carlo simulation using the discrete random variable, and create a graph to represent the possible returns over…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

762 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

9 Experts available now in Live!

Get 1:1 Help Now