• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 499
  • Last Modified:

Visio2000 cannot extract column definition for access97 with security

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
keyboards
Asked:
keyboards
  • 5
1 Solution
 
bruintjeCommented:
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
 
bruintjeCommented:
any update here? can we get closing recoms?
0
 
bruintjeCommented:
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
keyboardsAuthor Commented:
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
 
bruintjeCommented:
Hello keyboards ,would be great to know what comes out of it. :O)Bruintje
0
 
bruintjeCommented:
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
 
moduloCommented:
PAQ'd and points removed as proposed

modulo

Community Support Moderator
Experts Exchange
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now