Emergency, how can you tell if database is corrupted?

[MariaL]

Hello and thank you for your time. I am in sooo much trouble. I have two databases. In the first database I simple store a table of information. I linked this table to the second database where I have created forms and queries for day to day use. I have also created secondary tables on the second database to work off the linked table. When I work with these records on a form which has the linked table as the main form and all the secondary tables as subforms, the records I work with (I think) are corrupting. When I try to pull up the record again on the form it will not pull them up. The information is being stored in the appropriate table when I enter it. When I go to pull the record up again, it shows on my drop down list, but when I select it, it will not pull the reocrd up. It pulls all the other records correctly, but will not pull up records I have worked on since I linked the tables. Any ideas? How can I check for corruption? I appreciate any help I can get, my job is on the line. Thank you.

 

[pdldavis]

Hi, it doesn't sound so much like a corruption problem as it does a relational or maybe rowsource problem in the tables or in the way your subforms are linked. When you can store information but can't retrieve it - I would think it would be something along those lines.

Was this something that just started happening or is it something that has been a recurring problem?

If it just started happening, what ws the last thing you did?

 

[MariaL]

Thank you for your response. This started after I linked the tables. This is all in preperations to set security. I have three folders in windows. Folder A has the new database with the main table. Folder B has a database that links to the table in the database in folder A. I created the whole database first (Which worked fine), then I created the folders, copied the main table to folder A, deleted it from folder B and linked it back in from folder A. This is when I started having the problem. i know the information is stored correctly, but the form will not let me pull it up. I am trying to pull it up with a combo box, could this be the problem? Have you heard of any problems with combo boxes pulling correctly from linked tables? The name shows in the drop down window, but it doesn't pull up when you click on it. I'm going nuts. HELP.
I truely appreciate anything you can do to help me. Thank you!

 

[pdldavis]

Hi, When you're pulling from the combo box, you are probably wanting to display a record on your form or subform. You might want to check the row source of your combo box or of the form your data is associated with.

Try building a query with the tables in question.
See if you can edit the results. If you can, the tables are probably linked correctly and I would look again at the form row source.

A linked table shouldn't affect the combo box. It sounds like something else happened when you were moving tables around. You could do a compact and repair if you haven't tried that.

Failing all that, maybe someone else would care to comment on this or you can send me a zipped file with a little non-sensitive data in the tables and the form in question and I'll have a look. I have some spare time this morning.

ddavis@bibb.com

 

[ZOR]

Have you checked out the query within the combo box. Maybe its lost something in there. As pdldavis said, try putting together a temporary query together, run it and see if anything falls over. I know Access can be very touchy when moving tables apart and moving them. I always live in fear of relationships going wrong within linked tables. Fortnately only on a couple of times, found the primary autonumber escalate in numbering, producing some startling high numbers. Good luck.

 

[willir]

MariaL

Not sure how far you got into resolving your deliema. My first reaction was that data is not being linked properly. A real common symptom is you enter the data into your form and subforms. Exit the form and re-load it. Now the data is missing, ... or ... the same data shows for all records.

Look at the data at the table level. Is the data you entered in the tables? But you do not see the data when you look at the records at the form level?

A real common problem with this type of issue is...
- subform not linked - parent and child
- a query not returning the correct value.

I got to go home now to get my kiddies ready for fright night, but I will review this post later to see how far you got.

Richard

 

[pdldavis]

Hi, just a followup on this - she sent me the forms in question and it looked like the linked table's link was not refreshed for the new location. I did that and everything appeared to work correctly. I relayed that on and have not heard back so I assume the problem has been resolved.