Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

Strip Workgroup Permissions

Posted on 2006-11-09
8
358 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
Comprehensive Backup Solutions for Microsoft

Acronis protects the complete Microsoft technology stack: Windows Server, Windows PC, laptop and Surface data; Microsoft business applications; Microsoft Hyper-V; Azure VMs; Microsoft Windows Server 2016; Microsoft Exchange 2016 and SQL Server 2016.

 
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
 
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

This article is a continuation or rather an extension from Cascading Combos (http://www.experts-exchange.com/A_5949.html) and builds on examples developed in detail there. It should be understandable alone, but I recommend reading the previous artic…
The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
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 …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

790 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