Forms Stopped Working

[rokuk]

Hi there.

I have some forms set up to do searches on my Access 2003 DB table. The forms used to work fine, but now when I type in the parameters it finds no assets.

Even if I go into the table and copy/paste a parameter directly into the search form, it has stopped finding the assets.

If I run the same query as the form in a "new query" though, it finds the assets just fine.

I tried running the "Compact and Repair" option, but this has not fixed it. Is this a corrupted DB? Any suggestions on figuring this out? Is it possible to trouble-shoot, or am I pretty much dead here?

Thanks!

 

[wazz]

doubtful that it's corrupted. you probably just accidentally changed something. can you post your db?

 

[rokuk]

hi!

I can't, unfortunately...

That's the first thing I thought of too. But I "should" be the only one making any changes to it other than a few others who use the forms to run automated queries and sometime muck about in the data table itself, but not with the DB itself, only the table data. And I myself have not made any structural changes other than adding and removing some temporary tables and running some queries for a few months now.

IF (I know, that's an "IF") no one else had touched anything other than table data and the automated queries through the forms... other than being corrupted, what else could cause this sort of thing to happen (the forms just start returning 0 rows for automated queries)? If there are any ideas I can go and check for them, but I'm coming up blank...

Any ideas?

Thanks again = )

 

[missinglinq]

I wouldn't be so quick to discount the possibility of corruption. When something has worked for a time suddenly stops working, with nothing changed, corruption is always a good bet! You say the identical query works when run as a "new query" so why not simply re-create the search form using the query. Objects, such as forms, can become corrupted, a well as data in a database. ANother possibility which often works is to simply vreate a new, blanl database fiels and import all objects into it.

 

[rokuk]

.

Hi there!

I just read this as a suggestion elsewhere too, and I think it is definitely worth a try. I will attempt to reimport everything into another blank DB and see how things fare... thanks for the suggestion = )

 

[rokuk]

.

For future knowledge, and in case anyone was curious, this is what I did.

Things that did not work:
- Repair and Compact
- Decompile
- porting the DB objects into a blank DB
- exporting the table and reimporting into a new table in the same DB

What did work:
- have a working copy of an older version of the DB, and importing the tables with data from the corrupted DB to overwrite the older tables

So my guess is the problem was the connection in the corrupt DB between the DB structure and the data tables. Replace the structure with a working one and graft on the appropriate tables, and back in business.

Anyway, thanks for the suggestions all = )

 

[missinglinq]

And you thought your instructors were just trying to waste your time when they kept telling you to backup, backup, backup!

As I said, when something has worked for a time suddenly stops working, with nothing changed, corruption is always a good bet!

Glad you got it back up and running!