|
Home > Archive > MS Access data conversion > November 2005 > Permission probs w/Split database for Access97 & Access2003 Multi-
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Permission probs w/Split database for Access97 & Access2003 Multi-
|
|
| tiskal 2005-11-01, 1:24 pm |
| I've successfully split an Access 97 database and set up an identical front
end in Access2003. I've verified multiple times that my user group
permissions are defined identically for the tables in the back end as well as
the tables and all other objects in both versions (97 & 2003) of the front
end. However, with the Accesss 2003 front end, I've determined that users in
Groups with no Administrator nor "Modify design" rights to any database
objects can if fact change object permissions. I don't have the problem with
the Access97 front end nor the back end databases. I did have to create the
2003 front end by importing the objects from the 97 database. I'm only
working with copies right now and not the original database. Any advice on
how to eliminate this problems will be greatly appreciated.
--
Tim
| |
|
| Access has two different kinds of Administrator.
1) Administer Security (member of the admins group used to create the
database)
2) Administer Database objects (has admin permission on the object).
You should probably re-create the A2000 FE, making sure again
that you know which Workgroup File is in use, and which User
is the owner of the new objects.
microsoft.public.security is a good place to ask this kind of question.
(david)
"tiskal" <tiskal@discussions.microsoft.com> wrote in message
news:59B40BD5-02DC-4A8A-BD61- 7AFCBE67F240@microso
ft.com...
> I've successfully split an Access 97 database and set up an identical
front
> end in Access2003. I've verified multiple times that my user group
> permissions are defined identically for the tables in the back end as well
as
> the tables and all other objects in both versions (97 & 2003) of the front
> end. However, with the Accesss 2003 front end, I've determined that users
in
> Groups with no Administrator nor "Modify design" rights to any database
> objects can if fact change object permissions. I don't have the problem
with
> the Access97 front end nor the back end databases. I did have to create
the
> 2003 front end by importing the objects from the 97 database. I'm only
> working with copies right now and not the original database. Any advice
on
> how to eliminate this problems will be greatly appreciated.
> --
> Tim
|
|
|
|
|