Changes disappear

[DUX]

Hello All, I am wondering if any of you might know why it is that whenever i make changes to my access 97 query design, the changes sometimes appear on the report, sometimes don't, but in all the cases where they do appear, always revert back to the way they were before, after a few minutes? What would be causing this...I am at a loss. Please help?

Thanks,
Dux

 

[Pat Hartman]

Make sure that your report is actually referencing the querydef in its recordsource and not a SQL statement or a table name. In some cases when you make changes to a query, you may need to force the report (or form) to refresh its fields collection. To do that, delete the querydef name from the recordsource, save the report/form, then put the querydef name back and save again.

 

[DUX]

Hi Pat, yes it is referencing the querydef and not a SQL statement or table name. I am even finding that I am running into the problem when I make a change to a column heading in the report. I change it and it works fine for a few moments, but then I try it again and it has changed itself back to the way it was before I changed it. This is crazy...something very strange is going on here...I think. Is this normal? Any changes I make revert back after a short period of time...

Thanks,
Dux

 

[FoFa]

Is this a single user or shared DB, and where is the actual DB located?

 

[DUX]

This is a shared database....and it is located on the server (if that is what you are asking...i am not 100% sure that is what you are asking).

 

[KevinM]

I try it again and it has changed itself back to the way it was before I changed it. This is crazy...something very strange is going on here...

Spooky!

 

[Pat Hartman]

You should NOT be making changes to objects in a shared database. That is very dangerous. Make your changes in a back up copy and copy them back at a time when EVERYONE but you is out of the production db. I believe that Access help explains what is happening because in fact your changes are NOT being saved. If you have warnings off that would explain why you are not getting any messages. You can also read these articles from the Microsoft knowledge base:

ACC2000 Silent Design Changes May Be Discarded in MultiUser Environment (Q237938)

ACC2000 Exclusive Lock Required for Saving Design Changes to Access Objects (Q200290)

 

[DUX]

OK, I guess I need to explain myself....It is a shared database, when it is put into production, but right now, I am the only one who has access to it. The production database is completely fine right now, so that should not be a problem.

Thanks,
Dux

 

[DUX]

the changes remained in tact for one full day, but this morning when i checked on them, they had reverted back to what they were before......i'm lost as to what to do next?????

Dux

 

[KevinM]

Have you tried working from your local disk as opposed to the server. Surely it's better to develop locally than on-line.

 

[DUX]

all i am trying to do is change the column name of one column in a few reports...that's it. at some point i'd have to make the changes on the server side and then what would i do? i am making them on my developmental server and they don't stick, so i haven't even thought about making them on my production server...

 

[KevinM]

This is really odd.

The fact that you have made changes, seen those changes (for a full day) and then for them to revert back is very strange.

Unless there is a third party involved, either restoring a back up or something then I don't know.

 

[DUX]

it's quite frustrating...to say the least.

 

[Pat Hartman]

1. Are you working with the db on a network drive?
2. When you close the db, does the .ldb get deleted or does it remain?