Hi,
I am using MS Access 2013 as a front end to retrieve data from a database (SQL Server 2008 R2) via (ODBC), and the tables are linked.
I created a query to retrieve all the records in the table (categories) filter records based on an Arabic text in the field (name), for example:
select * from categories where name like '*خدمة *';
This query returns nothing when the table is linked to the SQL server, but when I converted the same table to local table, this query works and returns all the records with that condition.
I appreciate if you can help me to solve this problem.
Sulyim