Search and replace in tables

  • Thread starter Thread starter Kate Hather
  • Start date Start date
K

Kate Hather

Whenever I carry out the first search in my Access table I
get the following error message: Invalid Argument. Once I
click on ok the data I am searching for is found, so it
does actually work. I just wondered why on each initial
search I get this message.

I am using Access 2000.

My criteria for searching would be something like:

Find what: Philip
Look in: Case History : table (this is the only table in
there)
Match: Any part of field.

I looked up this problem in the Access Helpfiles and it
suggested checking my data separator was a full point (set
in control panel). I checked this and it is correct.

Hope someone can help.

Kate
..
 
Kate,

This behaviour ... is it on one table in particular or on any table? (If
you only have one table, either create a new one or set the Tools |
Options | Show Hidden Objects | Show System objects so that several
tables are present for test purposes.)

If it is localised to only one table, it might be that the schema for
the table is defective in some way.

CD
 
Chas

thank you for replying to me. I have show the hidden and
system objects which gives me more tables to test against.
The problem only occurs in my table and so could be a
problem with the schema for the table. Could you suggest
any other ways I can test my table.

Thanks again
Kate
 
Possible places to look would include:
- default value invalid/inconsistent with field type
- invalid/inconsistent validation rules
- use of Lookup (other than text box)

More generally, open up the table in Design view and step through each
field, carefully looking at the attributes in the bottom left of the
window. If you first take a copy of the table (or db), then any setting
you feel is suspicious could be removed for the purposes of testing.

Hopefully, this grind highlights a problem that you can fix. If not,
then there might be a bit of history needed ... how was the table
created, any imports or conversions involved etc.

CD
 
Back
Top