Solved

Strip Workgroup Permissions

Posted on 2006-11-09
8
357 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
Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

 
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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

Suggested Solutions

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
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 …

832 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