" Error - "The current user account doesn't have permission to ......"

[kingofthejungle]

"
Error - "The current user account doesn't have permission to ......"

Hello
I have a very important access database running on a Windows 98SE laptop with Access 97 on the laptop. I wish to have that database backep up and opened on an XP machine running Access 2003. The problem is that the laptop is a corporate laptop with lots of security features and the database can only be opened by that laptop. The laptop only has permissions to read the file, so cannot remove the protection. I have tried to copy the system.mdw file across to the xp machine (in the correct directory), but I still get the below error.

The current user account doesn't have permission to convert or enable this database.

To convert or enable a database, ensure the following:
* You must join the workgroup that defines the user accounts used to access the database.
* Your user account must have Open/Run and Open Exclusive permissions for the database object.
* Your user account must have Modify Design or Administer permissions for all the tables in the database, or it must be the owner of all tables in the database.
* Your user account must have Read Design permission for all objects in the database.
* Request that other users close the database.

I have tried to create a new database on the xp machine and import all the data into a new database, but again I get an error (but only when importing certain forms and macros) below:

"You don't have permission to import, export or link to 'item name'"

I have also tried to create a blank database and import data from the database into it on the laptop, with the same error message above.

Does anybody have any ideas about this one? For example is there a piece of software to remove the protection (not a password remover)? - help appreciated.

 

[wardster]

Not too sure if this will help as i dont have access to a97, but do your log in credentials place you in the admins group, if so - would it be possible to change the properties of each of the forms, queries etc... to give administer rights to the users group??? This is probably the only route i can think of to go along and is very time consuming, but should give the desired results, as always though - make a backup first

Hope this helps

Ian

 

[wardster]

Another possible route, copy the system.mdw file to another location and point to that mdw via a shortcut similar to:

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Performance_Pack\Local_Performance_Pack.mdb" /WRKGRP "C:\Performance_Pack\offline\Security.mdw"

Hope you get the problem sorted soon.

ian

 

[kingofthejungle]

Hi and thanks for the quick reply. The machine that can open the database has no windows logon system - but is only able to view the database and not change the permissions of the forms and queries. As for the other machines, they are all in the admin account in XP, yet can't even open or import from the database. I will try out the second suggestion now.

 

[kingofthejungle]

Ok, have tried the second suggestion, and after quite a long pause I had my original error "The current user account doesn't have permission to convert or enable this database."