How do I allow changes to be made to DB when not open exclusively?

[Guest]

I have a MS Access 2002 database that I would like to "turn off" the need to
open the database exclusively in order to modify the database.

There are forms in the database that change the value of controls such as:

if control.value = This Then control.enabled = True

I want the controls to be modified, but when the user closes the form, a
message pops us saying: "You do not have exclusive access to the database at
this time. If you procede to make changes, you may not be able to save them
later."

How do I eliminate this from happening?

Thanks!

 

[aaron.kempf]

a) don't use MDB it is for babies.
b) use Access Data Projects.

MDB has been obsolete every since the first beat of Office 2000.

-Aaron

 

[aaron.kempf]

you might fiddle with DOcmd.Close saveChanges = False.

it's like the 2nd or 3rd arguement there.

-Aaron

 

[Douglas J. Steele]

Is setting the Enabled property the only change you're making, or are there
others?

Theoretically, I believe you should be able to change Enabled without a
problem, but there are other changes that do require Exclusive access, and
there's no way around it.

 

[aaron.kempf]

or maybe they're using Docmd.Save somewhere instead of the
Docmd.DomenuItem with all the arguments for 'Save Record'

I think that it sounds like that might be the problem

 

[Guest]

Well you could at least stop the message with something like below on a
button or On Close event of the form:

DoCmd.Close acForm, "FormName", acSaveNo

 

[Guest]

I tried closing the form "without saving" yet I still get the message.

- The form changes the disable property in 1 control, and the visible
property in another control

Thanks!

 

[aaron.kempf]

open up the form vba and do a find for save and tell us what you've got
in there.

it just seems like somewhere along the line; you're trying to save the
form and not the record itself.

-Aaron