If there was one, of course, although I feel the error was of my doing in the first place. It was due to the version of Office I was using...

problem solved, no problem. End.

The exact error is :

run-time error 1004

General ODBC Error

cheers Frank.

Still leaves me with the same problem really I think.

Table of thousands of people, male/female of two different age groups.

need a random sample of 75 male/75 female....

Great! I have the following code. there is also an age field included which I want to use to split the results of the following query, i.e. 35 out of...

Nice one, NEWID() seems to work fine. Do I need to pass any values into NEWID(x)?

Seems to work fine without though......

Cheers

cheers frank, much appreciated.....

.....would NEWID() work for this kind of thing? do yu have any examples of this in action?

panic over, I have used sp_changeobjectowner

panic over, I have used sp_changeobjectowner

as i thought, just needed reasurrance. thanks graeme

Thanks guys.

Have been away...but watch this space Frank!

Will search on MS......

Sorry for all the followups,

is your solution by any chance related to dijkstras algorithm? or is that somethin different?

could you also explain the line

GID int IDENTITY

What does GID stand for / relate to?

Just to make certain, are there any alternatives that would be worth thinking about?

Thanks for that wayne, very helpful indeed, appreciate it