MS Access 97 (Please help I think I messed up :..(

[jlhiowa]

Hi. Hopefully someone can help me. I volunteer at a soup kitchen and when they found out I do computers they asked me to do their mailing labels becuz there was no one else. When I went in today I found out they were using MS Acess ('97) which I have not used before. Anyway here is the problem. This is what it looks like.. the title of the window says database. Then it has tabs. Under the Table (tab) it only has addresses. So I assume that must be the 'master' list with all the addresses. Under Queries (tab) there are several. The one I'm using is one I made called 2001 Contributors. I made it by going to the table and doing a sort/filter of fields that had a checkmark as a contributer. The last tab that I use is Reports. This has the acutal mailing labels. Ok now the problem is that I did not realize that Access must have some auto save feature. After I made the query of contributors I went back and looked at the Addresses Table and it had SAVED only the fields with contributors checked. Which I don't understand that becuz I did NOT ever save when I was in the Addresses table. I asked and she doesn't seem to have a backup. I know I should have backed it up before I started I guess and so that is my fault. And lots of other things I probably should have done (like said no I really can't I don't know how to use Access). But I tried and now it's messed up so I am trying to figure out how to fix it.
Since it is a database.. does this mean that the database, not the table is the 'master' list? If the Addresses table is the 'master' list then can I somehow put the other Queries back in to it? Becuz now the Addresses only has 350 some. Whereas it should probably have more becuz I know I saw 400+ somewhere, in one of the Queries or old Table or something.

I am going back in tommorow. I feel so horrible about this and I just want to fix it. Thank you to anyone who can help me.
Also if you don't know how to fix this but you do know how to backup and/or how to restore something from a diskette backup please post that also. I'm trying to find online things to read about Access but I don't know that I'll figure it out on time. And again I'd nvr used it before so I really have no idea about it.

 

[tempclerk]

Did you run a delete query or actually delete records? If you just applied a filter, the records are all still there. Open the table, click Records on the menu bar and click Remove Filter/Sort.

 

[jebry]

Hi!

I'm not sure that I have your answer but it sounds like all you need to do is remove the filter. With table as the active window, there is a button on the toolbar which looks like a funnel. Click on that button and see if the rest of the information returns.

hth
Jeff Bridgham

 

[RAtkison]

The only way I can see that you deleted some rows out of the Addresses Table was to run a delete query. On the Query tab, it would be listed with an X! beside the query name. If you didn't do that, the rows may not be deleted. To find out just double click on the table Addresses, right click in the Title Bar and choose Remove Filter. Any rows in the table should show up. If they don't, they must have been deleted. Hopefully you were looking at the rows selected from the query. They look just like the table.

Access 97 databases are stored in files ending in MDB. Everything is contained in that one file. Copying the file back to it's original location is all there is to it.
RKA

 

[nomus1]

I was thinking the same as jebry
If you don't see the filter in your toolbar

Try right clicking anywhere in your table
Click Remove Filter/Sort
Did that help?