akaivyleaf
Programmer
Has anybody done this? I have a database that was created in 97 and works like a charm. Security has been set, users are able to log in and out etc...
Now our IT department has rolled out 2000 enterprise wide. I've attempted to open the database and get an error that states: The current user account doesn't have permission to convert or enable this database.
It goes on to say that to convert or enable, ensure the following:
*You must join the workgroup that defines the user accounts to access the databsae
*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 databse, or it must be the owner of all tables in the databse
*Your user account must have read design permission for all objects in the databse
*request that other users close the database.
I am a user, plus I am the owner of the database which brings up a number of concerns I hope somebody can help me with.
1. I cannot open the wrkgadm.exe file, I get an error that says Can't open registry database. My user account has all the necessary permissions. (or at least it did in 97...)
2. If I convert the database, by copying the objects into another database what does this do to security?
3. Can I copy the objects because the database is "secure"
Anybody have any helpful hints, tricks or a solution for me?
Sharon
Now our IT department has rolled out 2000 enterprise wide. I've attempted to open the database and get an error that states: The current user account doesn't have permission to convert or enable this database.
It goes on to say that to convert or enable, ensure the following:
*You must join the workgroup that defines the user accounts to access the databsae
*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 databse, or it must be the owner of all tables in the databse
*Your user account must have read design permission for all objects in the databse
*request that other users close the database.
I am a user, plus I am the owner of the database which brings up a number of concerns I hope somebody can help me with.
1. I cannot open the wrkgadm.exe file, I get an error that says Can't open registry database. My user account has all the necessary permissions. (or at least it did in 97...)
2. If I convert the database, by copying the objects into another database what does this do to security?
3. Can I copy the objects because the database is "secure"
Anybody have any helpful hints, tricks or a solution for me?
Sharon