Current user can't convert or enable this database...Why?

[jsteph]

I get

The current user account does not have permission to convert or enable this database

...when tyring to open--and subsequently convert--an Access 97 .mdb opening with Access 2003.

Every one of the conditions they list below that error message is true--every object has every permission for every user and group--user, admin, users, admins, etc. Every object--the database, all tables, etc--everything is checked. The .mdb is not open by any other user. The only thing that might be causing this is that the owner of the .mdb in question is another user--but this is not listed as one of the requirements--that the current user also be the owner--so I'm at a loss as to why I get this error.

I guess it's more of a curiosity/academic question, in that I can work around this in several different ways, so I'm wondering if this is maybe a bug or a 'failure to communicate' in the error message, or could I have missed something security-wise here. The user account that happens to own the '97 .mdb does also exist in the Access 2003 .mdw--entered using the same PID, and I can log onto Access 2003 as that user and all is fine--but I'm just wondering if maybe this message is just worded wrong, and should simpley say "The current user must be the owner in order to convert or enable"?
Thanks,
--Jim

 

[lameid]

Obviously, the owner can do anything...

In my experience the required permissions are to be able to Open/run, Open Exclusive and Administer the database. Give the user those permissions and I suspect it will work.

In hind site in my situtations, the 'owner' is the one that has those permissions, so I may be misattributing the permissions.

Worth a shot though. If you have the time and gumption to test it, I'd be curious to see your results.

 

[jsteph]

lameid,
Yes, as I said, I can convert/enable this .mdb if I log in as the owner's user account--which is the same username with the same pid, and I believe it's the same .mdw even.

What I don't understand is why can't I convert/enable when I log in to Access 2003 under Admin?

In Access 97, I've given every possible permission to every user and group, including Admin. So Admin has open/exclusive, Administer, etc. rights to the .mdb, and Administer for all other objects. Yet I still get this error when I log into Access 2003 under Admin and then try to open this .mdb.
--Jim

 

[lameid]

Woops... I read over the database object in your initial post.

I am seeing the same thing.


The only thing I can think to try that I have not tried is converting my Access 97 MDW to 2003 and trying to convert it or recreating a native 2003 workgroupfile.

It sounds as though you have done that.