Access 2002 - Exclusive Use of db

[Shark]

went from using Access 97 to 2002 - am now getting messages saying I must have exclusive use of db. I haven't changed any of the options that were on the Access 97 db - all I did was update it to 2002 and am now getting these messages that are now requiring that everyone get out of the db for me to save data, etc. - Any advice on how to correct this?

 

[Brendan Reynolds]

Are you sure that you're getting these messages when you're simply changing
data, not making any design changes?

Access 97 was the last version of Access that permitted design changes
without exclusive access. All later versions require exclusive access to
save design changes.

--
Brendan Reynolds (MVP)

went from using Access 97 to 2002 - am now getting messages saying I must

have exclusive use of db. I haven't changed any of the options that were on
the Access 97 db - all I did was update it to 2002 and am now getting these
messages that are now requiring that everyone get out of the db for me to
save data, etc. - Any advice on how to correct this?

 

[Brendan Reynolds]

What's the exact message, and at what point are you seeing it?

--
Brendan Reynolds (MVP)

Yes - it is giving me the message for simply changing data. Any thoughts

on how to remove the exclusive access requirement?

 

[Shark]

The way the message is given is, "Microsoft Access can't save design changes or save to a new database object because another user has the file open. To save your design changes or to save a new object, you must have exclusive access to the file." All that I'm trying to do is add a record to a form and this is the message that is given to me.

 

[Brendan Reynolds]

Perhaps there's some code in one of the events being fired when you add a
new record that is trying to save a design change?

--
Brendan Reynolds (MVP)

The way the message is given is, "Microsoft Access can't save design

changes or save to a new database object because another user has the file
open. To save your design changes or to save a new object, you must have
exclusive access to the file." All that I'm trying to do is add a record to
a form and this is the message that is given to me.

 

[server di News]

sei proprio un deficente...

Perhaps there's some code in one of the events being fired when you add a
new record that is trying to save a design change?

--
Brendan Reynolds (MVP)


changes or save to a new database object because another user has the file
open. To save your design changes or to save a new object, you must have
exclusive access to the file." All that I'm trying to do is add a record to
a form and this is the message that is given to me.

 

[Shark]

I think the primary issue is that I have the data within this database with a link to another database that is being edited by others. In the past with 97 it has never been a problem but now with 2002 whenever someone else is in the other database and I open up the primary one it states that I must have exclusive use of the database. I would like to be able to add records also to the same database without having to do it exclusively. I figured there is some new set property that comes automatically with the new 2002 software that is checked and if it was unchecked would return to my previous settings on 97. Any thoughts on how to do this?

 

[Brendan Reynolds]

You can check in Tools/Options/Advanced that 'Default Open Mode' is set to
'Shared', but I strongly doubt that this is your problem - the error message
you mentioned in your previous post specifically mentions design changes. My
suspicion is that some code in the BeforeInsert, AfterInsert, or
BeforeUpdate procedures is trying to save a design change.

To the best of my knowledge, the default value of the 'Default Open Mode'
option did not change between Access 97 and Access 2002, but the ability to
save design changes without exclusive access did change, so the fact that
this did not happen in Access 97 is another reason why I think this is the
problem.

Of course, I could be wrong, and it can't hurt to check that the Default
Open Mode is set to Shared.

--
Brendan Reynolds (MVP)

I think the primary issue is that I have the data within this database

with a link to another database that is being edited by others. In the past
with 97 it has never been a problem but now with 2002 whenever someone else
is in the other database and I open up the primary one it states that I must
have exclusive use of the database. I would like to be able to add records
also to the same database without having to do it exclusively. I figured
there is some new set property that comes automatically with the new 2002
software that is checked and if it was unchecked would return to my previous
settings on 97. Any thoughts on how to do this?