Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

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

Status
Not open for further replies.

ken2834

Technical User
Jun 26, 2006
27
US
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.
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top