Query results are blank

  • Thread starter Thread starter Andy
  • Start date Start date
A

Andy

Help!
I've had an Access application for several years that has
run fine against an Oracle database using ODBC.

All of a sudden the queries I run return empty (or blank
columns) - The number of rows returned is correct but the
row values are blank (or empty).

Any ideas? Has some virus occurred the past few days that
I'm not aware of? I'm running windows 2000.

Thanks

Andy
 
Help!
I've had an Access application for several years that has
run fine against an Oracle database using ODBC.

All of a sudden the queries I run return empty (or blank
columns) - The number of rows returned is correct but the
row values are blank (or empty).

Any ideas? Has some virus occurred the past few days that
I'm not aware of? I'm running windows 2000.
Click to expand...

Compact and repair the frontend (if you haven't done so). If that
doesn't help, try relinking the tables - drop and recreate the ODBC
link (MAKE A BACKUP of the database of course!)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

criteria not working 4
Make table query won't run but Select will 3
Parameter Query Problem 3
Query returns incomplete results 4
Query results return blank rows.... 1
Query comparing two fields in a table gives wrong results-why? 3
Aligning beyond "Joining" in query--forcing blank rows to appear 11
Weird characters in query results 1

Back
Top