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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

Strip Workgroup Permissions

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
Psychotext
Asked:
Psychotext
  • 4
  • 4
1 Solution
 
Kelvin SparksCommented:
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
 
PsychotextAuthor Commented:
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
 
Kelvin SparksCommented:
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
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
PsychotextAuthor Commented:
Tried it on a couple of machines... same error.  I don't think it's hardware.  It is kinda odd.
0
 
Kelvin SparksCommented:
Can you try exporting from the old database to a new empty database (also 97)
0
 
PsychotextAuthor Commented:
Not tried that yet.  Will give it a go.
0
 
Kelvin SparksCommented:
The other thing you should do, and we should have done this first up, is to compact & repair the original database.
0
 
PsychotextAuthor Commented:
Seemed to do the job, thanks.
0

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

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