Search results for query: *

Thanks, PHV. It works! I guess I didn't refresh the linked tables before.

True I didn't have a primary key but I just used the auto number field as the primary key of the table. But the problem still occurs. Any other reason you could think of?

Hi, I have a form that consists several buttons. One is to delete a table A, then add records to several tables and eventually it will do a join and insert records to table A, and display a report. It always works while all tables reside in the same Access database. Now we are trying to...

Is there a way to generate SQL Script for triggers, like the way we do for tables, views and sp?

thanks, Castor66! It works too! :)

thank you very much, longhair. I will try to digest.

No, MS Office is not installed on the server. And I do prefer to to use DOS and create a batch to do it. Any suggestion to do so?

Is there a way to get date and time in DOS? I tried "date". but it prompts me to set a new date. In fact, I want to write a batch script to copy a file with the current date and time as the filename (the latest file in a directory) to another network drive. This batch will be scheduled to...

I found out that ASP.NET 1.1 was not enabled. Once I enabled it, everything works!! Thanks!

How to remove the exception entry? Where is it? I've never done it before.

So what exactly did you do in Application Pool Setting? Please let me know since I'm still trying to get it worked.

Yes, I created it already. I think there could be some other setting I need to change in IIS?

My admin. just installed Windows Server 2003 and I moved one of my web applications from my development server to the new server. The web app. works fine on my local machine. But when I tried it on the new server, it said "File Not Found" and "HTTP Error 404 - File or directory not found."...

I wonder how to use UPDATE trigger and get the old value of some column before update. I need to insert that value to a table. I created a trigger but it doesn't return any value. I have the print statement but nothing gets printed. CREATE TRIGGER Test_Update ON Test FOR UPDATE AS DECLARE...