DTS can run Visual Basic ActiveX Scripts.  Have you considered converting your Access macro to VB Script?

Which internal functions?  If you want help on this you'll need to be more informative.  I understand that you may not wish to publish your code, but a brief overview...

That is basically what Wayne West is saying, but you will need to be careful for two reasons.  Firstly, as Wayne states, it is not interactive and it will run...

The simple answer is no, but you can still run the Access subs/functions from your Form or Report, or better still rewrite them into a Stored Proc and get SQL...

I suffered the same problem as Kathi describes.  In my case the problem was due to user finger trouble where they would mis-enter a date, e.g. 01/01/101 instead of 01/01/01...

As Frank states the EM method can be scripted, just remember to test the script on a backup of the production database before running on the live system, as in...

How about Bulk Copying the rows that you want to keep into a new table, then drop the old, rename the new, and run a script to recreate the relationships/triggers/etc....

Hi Rhys,

Have you also opened UDP port 1434, which SQL Server uses to establish communications links from applications?  Also bear in mind that if you have installed the SQL Server as...

When I originally came across this problem I thought as you do, i.e. it shouldn't make a difference if you run the SET ANSI_NULLS ON within the procedure or outside. ...

The only thing that I can think of is that the other users haven't refreshed their EM table lists, etc. since your change.

How is your application accessing this table, e.g. ODBC, etc.?

I haven't tried exactly this my self, but the problem lies in that SQL needs it's BLOB data written in chunks, and MySQL may be the same.  ODBC (DAO) and OLEDB...

If you add a full text index to your table you can use the CONTAINS command to pick out indiviual words. 

See "Using the CONTAINS Predicate" in Books on...

Hi Cleech,

Try using a sub-query instead.  For Example, in Access a query could look like:

SELECT OrderId

FROM Orders

WHERE EmployeeID = DLookUp("[EmployeeID]", "Employees", "[

Another possibility is to insert all records from the source into A, then insert into B joining the source with A to select the identity field.  This method assumes that there is a way...