Deleted table/field still haunting me! Pls help

[HarmonyGirl]

In my Access 97 database, I have 2 forms, an input form and an edit form. On both forms, I had a Release combo box field that linked back to a table also named Release.

This field was no longer needed, so I deleted the table, and deleted the fields from both forms. I also deleted the field from the main table (Defect_New) that used this field. No other tables in the database reference this field.

However, now my Switchboard won't work and neither will my queries / macros -- I keep getting a prompt (Enter Parameter Value) and the parameter text to enter is referencing the previously deleted field. The effect is my form opens up completely blank - no fields at all are visible!

Thanks in advance for your time.

Harmony Brenner


[This message has been edited by HarmonyGirl (edited 03-14-2001).]

 

[Rich@ITTC]

Hi Harmony

You must still, somewhere, have a field on a form or query undelying a form that draws upon that deleted field and table.

You need to go through every object in your database in Design view and see if you can't locate the deleted field name. Access is like that - you need to be methodical and prepared to spend time checking everything ... but it is worth it in the end!

If you have numerous forms/reports/queries etc (I have some databases with 200 queries, 150 forms, 120 reports etc) you could save yourself some time by using Find & Replace - an Access Add-In created by Rick Fisher. The shareware version allows you to search for one phrase and locate all instances (in all objects and coding). It is a really excellent programme/add-in well worth buying if you want to do quite a bit of Access work (and no, I am not related to Rick Fisher - I am just a very satisfied user of this very handy Add-In).

His web site is:
http://www.rickworld.com/

HTH

Rich

 

[Atomic Shrimp]

One approach that just might work:

Recreate the deleted table with only a single row of data; fill this row with completely nonsensical values (this works best with numeric fields, as you can put a huge number in them).

Then examine your forms/reports for anything strange - you might then get a clue as to which object is still trying to use the table.

HTH

Mike

 

[HarmonyGirl]

Thanks to both of you for your replies.

I found what the problem was: I was using a query to link multiple tables, and using that query as the record source for my form(s).

After I updated the query to no longer point to the deleted tables, my forms were fine. I'm finding this occurs and reoccurs frequently, since I am still refining my database design.

Backups, anyone?