I tried to make a simple change to a report in Access 2003, however I

[ken2834]

I tried to make a simple change to a report in Access 2003, however I can't save the changes. I click the X, and it asks if I want to save, I respond "Yes", then nothing happens. What do you think the problem is? Thanks.

I did a DoCmd.SetWarnings True to make sure I wasn't missing any error messages, but this did not reveal anything.

 

[mp9]

Are other users logged into the db at the same time? Have you tried opening the db exclusively before making/saving changes?

http://www22.brinkster.com/accessory/

 

[ken2834]

I don't think anyone else is in the db? I have opened exclusively and tried to save, but the same thing happens.

The report says (Replicated) in the title, but the title of the db does not say this. What I think is the master db will not open, I get a message that says "The Microsoft Jet database engine stopped the process because you and another use are attempting to change the same data at the same time." I am fairly sure no one else has this master db open, so based on my research, I believe this means the db is corrupt. I have sent this db off to restoration service to see if the can restore it.

I would like to just convert my replica to its own master, and I understand I should do Tools -- Recover Design Master to do this, however, the Tools menu is not an option when I am in the replica. I see File Window Help, and that is it. I can right click on the toolbar and if I try to drag the "Recover Design Master" command up to the toolbar, it is grayed out. I have tried to set SetWarnings True via a macro to see if I am missing some error message, but this does not reveal anything. If I try to copy my report to another report, I get "Name conflicts with existing module, project or library". Thanks.