Hi,

I have an A2K app which I have just I have just started to convert to
multiuser. In order to change the ownership of all objects from 'Admin', I
have created a workgroup file, logged in with a new user ID and created a
new database. I have then imported all objects from my app. I have also
disabled all Admin permissions to the database.

The problem I have is that now everytime I try to make a design change I get
an Access message saying I do not have exclusive access to the database and
my design changes cannot be saved.

Any ideas? Thanks in advance for any help,

Jim F.

Sorry, an extra question: is there any other way of changing the Owner of
the database? And does it matter? (oops, thats 2 questions!)

Thanks,
Jim F.

"Jim Franklin" <(E-Mail Removed)> wrote in message
news:jaaUa.9368$(E-Mail Removed)...
> Hi,
>
> I have an A2K app which I have just I have just started to convert to
> multiuser. In order to change the ownership of all objects from 'Admin', I
> have created a workgroup file, logged in with a new user ID and created a
> new database. I have then imported all objects from my app. I have also
> disabled all Admin permissions to the database.
>
> The problem I have is that now everytime I try to make a design change I
get
> an Access message saying I do not have exclusive access to the database
and
> my design changes cannot be saved.
>
> Any ideas? Thanks in advance for any help,
>
> Jim F.
>
>

Hi,

Sorry Joan, I probably didn't give you all the information. I am aware of
the security FAQ and do intend to follow it (but thanks anyway.)

At the moment the database is only on my PC, in development stage. My
concern is that with the newly created database (i.e. after all objects have
been imported) I get this error even though I am the only person who has the
file open.

Does this help? Once again, thanks,
Jim F.

"Joan Wild" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> First, you missed several steps in securing it, so it won't be secure as
is.
> I suggest you follow *every* step in the security FAQ. None of them are
> optional.
> http://support.microsoft.com/?kbid=207793
>
> Regarding the 'do not have exclusive access' message, starting with 2000
you
> cannot make design changes while anyone is using the database. If you
> haven't done so, you should split your database. Backend on the server, a
> copy of the frontend on each person's computer. If you are making design
> changes to the backend, you'll need to get everyone out and open it
> exclusively. Since your copy of the frontend is on your local machine,
you
> will have exclusive access to it, and can make design changes.
>
> Importing objects to a new database, owned by 'any user but Admin' will
> ensure that they own all objects. Does it matter?...if you have to
> ask...:-)
>
> Of course it matters. See
> http://www.ltcomputerdesigns.com/DatabaseOwner.htm
>
> --
> Joan Wild
> Microsoft Access MVP
>
> "Jim Franklin" <(E-Mail Removed)> wrote in message
> news:YuaUa.9440$(E-Mail Removed)...
> > Sorry, an extra question: is there any other way of changing the Owner
of
> > the database? And does it matter? (oops, thats 2 questions!)
> >
> > Thanks,
> > Jim F.
> >
> > "Jim Franklin" <(E-Mail Removed)> wrote in message
> > news:jaaUa.9368$(E-Mail Removed)...
> > > Hi,
> > >
> > > I have an A2K app which I have just I have just started to convert to
> > > multiuser. In order to change the ownership of all objects from
'Admin',
> I
> > > have created a workgroup file, logged in with a new user ID and
created
> a
> > > new database. I have then imported all objects from my app. I have
also
> > > disabled all Admin permissions to the database.
> > >
> > > The problem I have is that now everytime I try to make a design change
I
> > get
> > > an Access message saying I do not have exclusive access to the
database
> > and
> > > my design changes cannot be saved.
> > >
> > > Any ideas? Thanks in advance for any help,
> > >
> > > Jim F.
> > >
> > >
> >
> >
>
>

"Jim Franklin" <(E-Mail Removed)> wrote in message
news:BPwUa.694$(E-Mail Removed)...
> Hi,
>
> Sorry Joan, I probably didn't give you all the information. I am aware of
> the security FAQ and do intend to follow it (but thanks anyway.)

That's good - I still have doubts. Your first message was in past tense, as
though you had already done it. Now you say you 'intend to follow it'. ???

>
> At the moment the database is only on my PC, in development stage. My
> concern is that with the newly created database (i.e. after all objects
have
> been imported) I get this error even though I am the only person who has
the
> file open.
>

Open the file exclusively. File, Open and in the lower right you'll see a
dropdown where you can choose open exclusive.

--
Joan Wild
Microsoft Access MVP