Hi Sergey,

There's something unusuall about the code below

csql = [Select * from Accounting!datacenter where dcno = 1]

I tried to change the connection of the odbc to a copy of the accounting database and when I tried to execute the code above, it displayed the correct record. To further test the result, I returned to ODBC Manager and change to connection to the original database and when I tried to execute the command, it displayed no record. I'm thinking if there is something wrong with my database not the syntax, I tried to verify the fields that were on the original database vs the fields on the other copy and they are only the same. They both have a table name Datacenter with data type I(4), index on dcno, allowing null values...

the databases are located on different folders.
the one that works is located on my server G:\MYSystem\SystemHelp\MicroFilesCP
the other that does not work is at G:\MYSystem\SystemHelp\FilesCP