Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 479
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Featured Post

NFR key for Veeam Backup for Microsoft Office 365

Veeam is happy to provide a free NFR license (for 1 year, up to 10 users). This license allows for the non‑production use of Veeam Backup for Microsoft Office 365 in your home lab without any feature limitations.

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