Thanks for all the help! :Whistling: that'll be me then.

I have actually resolved the problem.

I used the thread safe version php_sqlsrv-ts.dll instead.

PHP was...

I checked the Apache error log and it said that the sqlsrv.dll could not be loaded

[font="Comic Sans MS"]PHP Warning: PHP Startup: Unable to load dynamic library 'C:\\xampp\\php\\ext\\php_sqlsrv.dll' - The...

Further to my last posting I have found out some info and had a go at it.

First issue is the location of php.ini

On my system, PHP and Apache are installed...

There are two different versions of the PROC, both which work just fine when running against the passed parameters with or without access filters.sorts in Access 2000.

In Access 2003, the...

Yep, did that too before I posted the original message.

However, the filter sort does NOT have to have a requery applied to it to re-populate the subform in this case,...

Sorry, that doesn't make sense.

strSort = "'" & crs_CoreID,crs_CourseID,Delname & "'"

Does not even pass the line Syntax check.

strSort = "'" & "crs_CoreID,crs_CourseID,Delname" & "'"

Might be what you meant, but that...

Is your for based upon a Table, View or a Proc?

It is only procs that I appear to be getting issues with.

To add to this.

I tried re-writing the PROC so that it was Dynamic.

I passed all parameters for filtering and sorting etc to the PROC.

It then Creates on the FLY DYNAMIC...

To Clarify, I have a PROC on the SQL Server (I could attach the text if necessary).

It has 2 parameters passed to it, and works just fine when the...

Thanks.

I'll give that a go.

It still does not get MS out of the issue that

their Error Trap in Access VBA doesn't trap all errors correctly.

It is true it is not often, but to be honest the question is more academic now than crucial to my life. I have found a solution where the error...

I used this method, although I did not need to use table function because it worked fine on table direct.

I did need to reset rank to null where value was...

I'll experiment with this and see if embedding the table variable in the function makes it perform any quicker than having it as a separate function.

Thanks for input.

Andrew