D
Derek Curtis
I have a customer who was running an application in Access 97 which I then
upgraded to Access 2007 in January. When I upgraded it, I didn't realize
user level security was applied to the database. I guess there have been
problems with some of the functionality of the database for some time, but
they didn't make me aware of it until now. When investigating the problem,
I've found that some of the objects have a different owner and the current
user "admin" has no permissions on those objects. How can I change the owner
of those objects? I tried opening the old access 97 database to see who the
owner of the objects were, but they were all set to admin so I'm not sure
what the problem is.
upgraded to Access 2007 in January. When I upgraded it, I didn't realize
user level security was applied to the database. I guess there have been
problems with some of the functionality of the database for some time, but
they didn't make me aware of it until now. When investigating the problem,
I've found that some of the objects have a different owner and the current
user "admin" has no permissions on those objects. How can I change the owner
of those objects? I tried opening the old access 97 database to see who the
owner of the objects were, but they were all set to admin so I'm not sure
what the problem is.