No Current Record?

  • Thread starter Thread starter Lynne
  • Start date Start date
L

Lynne

I have a large table that I have to add records to a
couple of times a week. Usually I just import my records
into the existing table - no problem. Now for some reason
when I tried to import my new records, I get a popup that
says "No Current Records". So I imported my records as a
new table and tried to do a simple append query and I get
the same error - "No Current Records." I CAN append the
old table to the new table but I lose the sort order. I
have never seen this error before. Anyone have any ideas?

TIA,
Lynne
 
What does your append query look like? Is there a "where" clause in it,
maybe it's a data problem and the conditions are not being met.
 
Lynne said:
I have a large table that I have to add records to a
couple of times a week. Usually I just import my records
into the existing table - no problem. Now for some reason
when I tried to import my new records, I get a popup that
says "No Current Records". So I imported my records as a
new table and tried to do a simple append query and I get
the same error - "No Current Records." I CAN append the
old table to the new table but I lose the sort order. I
have never seen this error before. Anyone have any ideas?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

I've never seen that before.

You don't need a sort order on a table. Usually, the order, if there is
one, is first added as the "first" record and last added as the "last"
record. If you want a sort order, create it in a query of the table.

Perhaps, taking off the filter/sort will fix the problem.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQGSVLIechKqOuFEgEQLyKwCg+OO35PjrzmzWcflr8tgOM8XFLqoAn1/e
N6kW8+TlfXTsMOrkeeCThR3J
=gSRS
-----END PGP SIGNATURE-----
 
Back
Top