I figured out a stupid way to do it.  But if someone shows me a better way, I will be really appreciate.

My way is:

select datename(mm,convert(datetime,[month]+'/1/00'))

from mytable

I use this way:

1. Link the server to your local machine:

         USE master

         GO

         EXEC sp_addlinkedserver

        'sqlserver', /*Name of the linked server*/

        N'SQL Server'

2. run select to make...

I created store procedures in the backend, call it from pass-through queries in front-end, and use them as recordsource.  By doing this, I have a lot of flexibilities to manupulate...

So why don't you limit your data return like specifying a where clause in your store procedure? Another thing you can do is run a access query to filter your...

Thank you for all of the excellent helps. I tried all of the ways, and they all work great for me. 

Minh

I had the same issue.  All I did was to make a full backup, then dbcc shrinkfile.  My log files were shrank immediately.

Minh

Here is what Allen Cui showed me before:

select a.*, IDENTITY(int, 1,1)  as Counter

into #tmptb  

from  yourtable a

Thank you for all of the ideas.  I checked but it seems that my case was not belong to any cases that you mentioned:

1. The client machine run on XP with...

I see.  Thanks a lot.

How's about GETUTCDATE()? Can I used this function instead? Actually, I'm not sure how this function will work.

Minh Vu