Access 2000 database & Prog running under Access 2003 SP1

P

Paul Buckman

G'day, This db has been working well for a couple of yesrs & reached around
80mb in size. Recently when calling up a worksheet report (like a Purchase
Order Form or Jobcard" - I get a message asking for an imput like you get
from a parameter query except that it is asking for the tablename eg
tblCostCentre. The table physically exists & is linked - the linking is
correct. your can select the table & view its contents. When you run the
query it asks for a value for tblCostCentre - not for a field value within
that table.

Question - is this a symptom of the db outgrowing available resources, or is
there another reason.

regards
 
A

Arvin Meyer

That usually means it can't find the table. 99 times out of a 100 it is
because something is misspelled. The other time it's because there is a
reference to that table in a parameter and the table is no longer included
in the SQL statement. On a very rare occasion the table has a corruption in
it (1 or more records) Compaction and repair will usually fix that
situation.

80 Mb is less than 5% of the specification's stated capacity. It is also
less than 20% of its practical capacity (depending upon activity and number
of users)
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
 
V

Van T. Dinh

It sounds to me more likely to be corruptions ...

Re-create the Query and see whether it still think the Table Name is a
Parameter.
 
Top