Solved

Strip Workgroup Permissions

Posted on 2006-11-09
8
356 Views
Last Modified: 2012-06-27
I have been trying for most of the day to convert an access database from 97 to 2003 and I'm not getting anywhere.  When I open the file I get the message: "The current user account doesn't have permission to convert or enable this database".  I have tried joining the workgroup as administrator but this hasn't worked.

So... I opened the file up in 97 and gave the admin account full permissions on everything.  But this didn't work either. =(

Is there any way of completely removing the workgroup permissions?  I would import the objects rather than converting the file but I'm getting errors doing it that way.

Thanks in advance.
0
Comment
Question by:Psychotext
  • 4
  • 4
8 Comments
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 17913823
Login using Access 97 as the administrator. Close the old database leaving Access open (so you're still logged in as the administrator person). Create a new blank 97 database & try and import all the objects from the old database.

This should create a databse that you "own". You should now be able to convert this using Access 2003. THius method will require you to re-estbalish the security in 2003 if you need it. You'll need to play around with it, if you still need the security - it's acomplex issue to get right and you need to follow the established rules.


Kelvin
0
 
LVL 2

Author Comment

by:Psychotext
ID: 17913881
I'm not so worried about re-doing the security, but when I try to import I get all sorts of error messages like "Network or disc error" and "$table" could not be found.
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 17913949
The network/disk one tends to be a hardware problem - server playing up or similar.

I'd be very cautious about the environment. You could try using another PC, I struck a dud one once when migrating one database to a leter version - created all sorts of havoc.
0
 
LVL 2

Author Comment

by:Psychotext
ID: 17914067
Tried it on a couple of machines... same error.  I don't think it's hardware.  It is kinda odd.
0
Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

 
LVL 22

Accepted Solution

by:
Kelvin Sparks earned 500 total points
ID: 17914274
Can you try exporting from the old database to a new empty database (also 97)
0
 
LVL 2

Author Comment

by:Psychotext
ID: 17914399
Not tried that yet.  Will give it a go.
0
 
LVL 22

Expert Comment

by:Kelvin Sparks
ID: 17917901
The other thing you should do, and we should have done this first up, is to compact & repair the original database.
0
 
LVL 2

Author Comment

by:Psychotext
ID: 17930038
Seemed to do the job, thanks.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

911 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