Hi Guys,

Many thanks for you input on this.

Amit - unfortunatly I get the following with your suggestion -

Server: Msg 130, Level 15, State 1, Line 3

Cannot perform an aggregate...

This is my Sales Ledger Sage Accounts on Stop procedure. It uses a usystablename table to hold the data.

Basically delete the usys table, re-create it and...

Hi Steve,

The way I have it working at present with SQL and DTS, is that for example, the user opens a customer record form in Access, then clicks to view the...

Hi Steve,

I have an Access front end and SQL backend, so am using an ADP route.

Sage was not the reason for going this route, but it does mean the...

I'm using DTS with an ODBC driver to pull data out of a Sage Line 50 system into SQLServer.

http://www.triplentry.com have a product that apparently will import and export to Sage,...

Hi Erik,

It took me something like 3 hours to rename all the problem table out of the way, create new tables, transfer the data and re-build and sort out the reationships/constraints...

Hi Remi, Richard,

Many thanks for your suggestions.

I'm never sure what I'm seeing with the Profiler, but with a table that works, I'm getting a SELECT *, sql_variant_property(value, 'basetype') AS...

David,

Thankyou very much, it works perfectly.

Tim

Thank you, that worked a beautifully (with a slight change of the code).

And yes the calling code will always ensure taht at least one param is set.

Many thanks

Tim