Anyone please?

Maybe something like this? 

CREATE PROCEDURE spDoSearch 
@FirstName varchar(25) = null, 
@LastName varchar(25) = null, 
@Title varchar(25) = null
AS BEGIN  
SELECT ID, FirstName, LastName,...

The main problem is how to pass only one variable or 2 variables or more into SP. 
And what if my variables will be null ?

Jacek

Hi,

I move the topic to another forum (Access forum):

http://www.accessforums.net/showthread.php?t=69646&p=381414#post381414Best wishes,
Jacek

J Livingston SQL this is not helping. 

I...

Thank you very much markdh.climb!

 I would, for smaller datasets, keep the last saved/original values in an array for comparison
What do you mean by this ?
Please...

Hi markdh.climb,

wow thank you for your answer!
I am using ADO connection in my FE often for example in Excel applications 🙂 

So it is very interesting...

Yes,

I can create query in MS SQL Server, save it and simple run via VBscript code. 
So i am using T-SQL within Query Designer in MS SQL Server.

Thank you Guys! 

The best method and the simplest for me is creating VBscript and run it via tash scheduler.

Best wishes,
Jacek

Hi markdh.climb. 

Thank you,
could you please explain more what do you mean saying using ado instead? Maybe you can give an example?

I read that in Access...

Hi Guys,

thank you!
I do not have SQL server Agent and standard SQL edition.

This code:
declare @cmd varchar(5000)
select @cmd ='if ''tempdb''...

Hi Guys,

relationships where moved all together into MS SQL Server so it is great!

.
Problem is that MS Access in FE doesnt see my relationships from MS...

Thank you John,

I will test it !
Jacek

thank you John! 
Ok this is better idea to have backups on different drive then C drive. 

Question about tash scheduler in Windows. I can set up the task...

I think that i will have to use VBscript anyway because i have to run scripts outside from SQL Server express because i do not have Job Assistant here...