Cheers guys

but the problem is when accessing a linked table via code.

i.e. linked table = 'subscriptions'

code =

dim mydb as database

set mydb = currentdb()

dim myrs as recordset

set myrs = mydb.openrecordset("subscriptions")

This...

It sure does.  Infact I can set up a linked server that accesses an Excel file on the same drive.

Not permissions, just me being an arse.

Failed to copy ALL required files to testing directory.  Did that and all works fine.

Thanks

I have created a sp which populates a table to be the source of a report.  The data is financial data based on products sold.

I wish to do the following...

Not a one time job I'm afraid.  Will be run daily after the conclusion of runnind a stored procedure.  If possible was looking to append code to the end of...

Thanks Ray

Was indeed NULL field values.

That's cool cheers Ray.  Will look at that.

Thanks a lot Phil.  Got the debugger working (that could have saved me so much time over the last 2 months) and sorted my code problem with a few minutes.

No yellow arrow.

I suspect the problem must be that when I click 'execute' to debug, I get the following msg "SP debugging may not work properly if you log on...

Hmm, still trying to get debugging to work.  I right click on my 'sp' and select debug.  This shows my code in the right pane.  However I seem...

No, I assigned the return value of the function to a variable and then selected the variable.

Is there a SQL debugger.?

My version of Visual Studio does not support debugging of...

I suspect a 'feature' Phil.

The function does appear to work correctly as it returns the correct value if called from a store procedure that contains no other code.  It also...

Here's the code.  Not too easy to read here but I'm sure if you cut and paste it'll be easier.  The function call in question is near the end of...