Thanks for your reply. I know how to reduce the log file size but I want to know is why that log file size is increased quickly. When I use...

Dear Sr,

          Thank you so much for your advice. I also would like to know how to do replication process.

Best Regards,

MK.

Thanks a lot! I got it.

Grasshopper,

         Thanks a lot!

MK.

Dear Grasshopper,

        Thanks for your answer but my query statement is long, over 255 characters. So I have to seperate many strings, isn't it?

Best Regards,

MK.

Dear Frank and David,

       Now I got it! Thank you so much for your help.

Best Regards,

MK.

Dear Frank,

          I've tested it according to your sql statement but I can't get the result. I only get this : **:**. Pls help me again!

Best...

I want to know any stock inventory which is connected to account control.

Best Regards,

MK.

Dear all,

        Thank you so much for your suggestion. I get it what I need using master table.

Hello David Burrows,

       I'm sorry, my mdb and SQL are not in the same server. SQL is in Remote server and mdb is in local machine. Do you have any...

Thanks for your interest. I have a table 'Table1' in Access Database and I also have a tabel 'Table2' in SQL Database. In Table2, there are two  fields 'ID' and 'Status'...