triggers created in ADP files valid in SQL Server 2000? 1

[psimon88]

Hello

I have access to an ADP file in ACCESS 2003 and have started looking into creating triggers. The ADP file is linked to tables from a backup of our production dB. Before I get too involved in creating triggers for ADP, I'd like to know about the transferability of triggers from projects to SQL Server 2000. I know that the latter uses DTSs. I'm not an admin on SQL Server 2000 and would very much like to do my development on my own machine and then export the SQL to them to deploy in production (off SQL Server 2000).

Thanks in advance,

ps

 

[SQLBill]

The trouble with creating scripts of any kind in Access and importing them to SQL Server is that they don't use the same SQL. Access uses (I believe) Jet-SQL and SQL Server uses Transact SQL (TSQL).

The basic syntax is the same in both, but there are enough differences to cause problems.

Examples: Access uses NOW() for the current date, SQL Server uses GETDATE(). Access has IIF, SQL Server uses CASE.

There are more and I don't know if DTS translates the differences properly.

-SQLBill

Posting advice: FAQ481-4875

 

[psimon88]

Thanks. Do you know of any translation mechanisms to go from JET-SQL and TSQL?