Trouble with linked tables

[NXMold]

I have a front-end / back-end database where both mdb files are on a network server (same folder). There are only three main tables, and a couple of complex forms. Typical 2-4 concurent users. Most forms and reports are based on queries (queries are saved in front end).

1) I have a table "UserTable" with a field that was deleted some time ago. When I open this table in the front end, it gives me that little dialog "Enter Parameter Value" "UserTable.[missingfield]"

I can find no reference to this field in the table (front end or back) or in the relationships. I don't understand where this error is coming from, or even where that field name resides anymore.

2) The database is SLOW, 30 seconds to open, sometimes 4-6 minuets to get something open in design view.

Any ideas? I have run the compact and repair database utility, and for grins the performance analysis. I relinked the tables. Nothing changed.

 

[RoyVidar]

For such, I'd usually start with dumping the form contents to a searchable text file

[tt]application.saveastext acform, "<name of form>", "c:\tst.txt"[/tt]

then search the text file. But since it's tablename.fieldname, I'm more inclined to thing that you've forgotten to remove the field from one of the underlying queries. It doesn't necessarily need to be the forms query, but row source for combos, listboxes and whatnots.

Then, another place to look, is if you've used any conditional formatting - I don't remember whether that's accounted for through saveastext.

For speed, I'd take a look at for instance

http://www.granite.ab.ca/access/performancefaq.htm

and

http://www.fmsinc.com/tpapers/faster/index.html

Then perhaps also

http://www.granite.ab.ca/access/decompile.htm

(but do remember to close all instances of Access between 2 and 3.

Roy-Vidar

 

[Remou]

As the table is based on a saved query, have you checked the form, query and / or table properties (query and / or table in design view) for a sort or filter field?

http://lessthandot.com

 

[NXMold]

Good ideas, I hadn't considered listsource and such places. Making the text file certainly looks useful.


I need to clarify, when I open the table itself in the database window (front end only) it asks for the value of a missing field.

I'm used to seeing this behaviour in queries, but not in a table itself. I found that I can delete the table and link it again, problem solved.

 

[PHV]

You had to refresh the linked table(s).

 

[JoeAtWork]

As PHV says, refresh the linked tables through Linked Table manager. Changes to the backend table are not shown in the front-end until you do this.

Joe Schwarz
Custom Software Developer

http://www.plandev.net