T
The parawon
When I run queries that previously gave me 200,000 + records in Access 97, I
now get zero records from the make- tables query. There is no error message
simply, "You are about to post 0 records". One of the tables is a
"make-table" I made previously from one of the dBASE tables back when I had
Access 97. One of the tables I'm getting data from is a linked dBASE 4 that
is very large(over a million records). The tables have a relationship with a
primary key from the make table(part_number). I am able to look at all the
records of the dBASE table and also I am able to look at all the records in
the make-table I made with a query, and lo-and-behold all the records are
there, but when I run the query, none are posted. The "make-table" I
created in Access 97. with relatively few records (3000). I looked in
"tools"="references", and I put DAO 3.6 as top priority followed by OLE
automation.
Any help would be greatly appreciated. Even a hint in the right direction
would help a lot.
Thanks,
Zack Andersen
now get zero records from the make- tables query. There is no error message
simply, "You are about to post 0 records". One of the tables is a
"make-table" I made previously from one of the dBASE tables back when I had
Access 97. One of the tables I'm getting data from is a linked dBASE 4 that
is very large(over a million records). The tables have a relationship with a
primary key from the make table(part_number). I am able to look at all the
records of the dBASE table and also I am able to look at all the records in
the make-table I made with a query, and lo-and-behold all the records are
there, but when I run the query, none are posted. The "make-table" I
created in Access 97. with relatively few records (3000). I looked in
"tools"="references", and I put DAO 3.6 as top priority followed by OLE
automation.
Any help would be greatly appreciated. Even a hint in the right direction
would help a lot.
Thanks,
Zack Andersen