Database

connection.Open();
if(File.Exists("C:\\opened.txt") == true && File.Exists("base.ldb") == true)
  MessageBox.Show("Connection is opened by your application");
if(File.Exists("base.ldb") == true)
  MessageBox.Show("Connection is opened by Access client");
Else
  File.CreateText("C:\\opened.txt")

connection.Close();
if(File.Exists("C:\\opened.txt") == true)
  File.Delete("C:\\opened.txt")

ALTER PROCEDURE dbo.GETRECORDS
	-- Add the parameters for the stored procedure here
	
AS
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

   -- VARIABLE DECLARATION
	DECLARE @SENTBY INT
	DECLARE @SENTON DATETIME
	DECLARE @ACCEPTBY INT
	DECLARE @ACCEPTON DATETIME

	DECLARE @NEWTBLSENTBYSENTON TABLE 
	(
		SENTBY INT,
		SENTON DATETIME
	)

   -- STEP 1: DECLARE A CURSOR
	DECLARE MYCURSOR CURSOR FOR

		SELECT    SENTBY,SENTON,ACCEPTBY,ACCEPTON
		FROM      TBLSENTBYSENTON

	-- STEP 2: OPEN THE CURSOR
	OPEN MYCURSOR 

	FETCH MYCURSOR INTO @SENTBY,@SENTON,@ACCEPTBY,@ACCEPTON

	-- STEP 3: START THE LOGIC

	WHILE @@Fetch_Status = 0

	BEGIN

		-- STEP 4: INSERT RECORDS INTO TABLE @NEWTBLSENTBYSENTON
		--		   BASED ON THE LOGIC PROVIDED

			IF(@SENTBY = @ACCEPTBY)

			BEGIN
				INSERT INTO @NEWTBLSENTBYSENTON(SENTBY,SENTON)
				VALUES(@SENTBY,@SENTON)
			END

			ELSE

			BEGIN

				INSERT INTO @NEWTBLSENTBYSENTON(SENTBY,SENTON)
				VALUES(@SENTBY,@SENTON)

				INSERT INTO @NEWTBLSENTBYSENTON(SENTBY,SENTON)
				VALUES(@ACCEPTBY,@ACCEPTON)
			END

	
	-- STEP 5: GET THE NEXT RECORD
	FETCH MYCURSOR INTO @SENTBY,@SENTON,@ACCEPTBY,@ACCEPTON           

   END

	--STEP 6: CLOSE THE CURSOR
	CLOSE MYCURSOR

	--STEP 7: DEALLOCATE THE CURSOR
	DEALLOCATE MYCURSOR
	
	SELECT * FROM @NEWTBLSENTBYSENTON
END

Sentby		SentOn 
1	2009-06-15 19:40:36.000	
32	2009-06-29 13:36:59.450	
1	2009-06-30 12:25:45.303
1	2009-06-15 19:40:36.000	
1	2009-06-16 13:19:34.693	
1	2009-06-15 19:40:36.000	
2	2009-06-15 19:40:36.000	
1	2009-06-16 19:40:36.000

SELECT Sentby,SentOn

       FROM tblSentBySentOn

       UNION

       SELECT AcceptBy,AcceptOn

       FROM tblSentBySentOn

       WHERE Sentby <> AcceptBy

SELECT A.Sentby, A.SentOn

FROM(
		SELECT Sentby,SentOn

		FROM tblSentBySentOn

		UNION 

		SELECT AcceptBy,AcceptOn

		FROM tblSentBySentOn

		WHERE Sentby <> AcceptBy
	) A ORDER BY A.SentOn

Create a table (say tblQuestions) with QuestionId(int Primary Key), Questions(Varchar(50))

QuestionId Questions
---------------------
1	Q1
2	Q2
3	Q3
4	Q4
5	Q5
6	Q6
7	Q7
8	Q8
9	Q9
10	Q10
11	Q11
12	Q12
13	Q20
14	Q25
15	Q30

SELECT QUESTIONS 

FROM TBLQUESTIONS 

WHERE QUESTIONID = ROUND(((30 - 1) * RAND() + 1), 0)

SELECT QUESTIONS 

FROM TBLQUESTIONS 

WHERE QUESTIONID = CAST(RAND() * N AS INT)

SELECT QUESTIONS 

FROM TBLQUESTIONS 

WHERE QUESTIONID = ABS(CAST(NEWID() AS binary(6)) %N) + 1

Send the random numbers from your front end application to the backend either in INLINE SQL or in STORED PROC, and retieve the questions based on the QuestionId.

jamith wrote:

How i connect a database in the main server to a client machine i am using SQL 2003