Hi there,

I had a similar problem... there's not much out there, is there!!

I use the servername\IIS_WPG account in SQL2000 for my ASP.NET applications on SERVER 2003... try using that & all...

Be aware that using ACCESS will require each user to have it (ACCESS) installed on their machine with a licence for each.

If you're going to get someone in to do this...

Jon McMullin - You need to read the rulles before posting unhelpful comments.

People need to know that they can post their problem here without people sneering at them - we've...

The article on Dynamic SQL linked by PW is very comprehensive.

How did the 25,000 user IDs get to the webpage in the first place? Did they come from the database?...

Hi Julie,

Apparently the default is the first 8 rows only, this value being stored in HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Jet\4.0\Engines\Excel\TypeGuessRows

If you set the value to 0, the number of source rows scanned is 16384!

There's some logic...

I copped out and moved the row....!!!LOL

hello people,

Sorted this one myself... managed to find this

http://support.microsoft.com/default.aspx?scid=kb%3BEN-US%3BQ281517

cheers anyway

Tim

Thanks guys, I wasn't GROUPING and that was my problem.

What can I say, I'd be scuppered if it wasn't for guys like you out here.  Who knows, one day I...

Sorry DINESH, it's before 6am as I type this and I'm not yet awake! The above message should have included you in my thanks.  Lets hope my brain works a...

Doh!!!!

Thanks Mexicano, I can't tell you how long I stared at that!  How basic can you get? I was fixing on the EXISTS...

WOW!! I was hoping for some help but I can't believe the trouble you guys have gone to to sort me out! Many, many thanks!!

SSTECHER - that worked a...

urgh, I've just seen that the above has had all its tabbing/indentation removed.

Sorry...

Thanx guys, hope its not too big... The problem is with the outermost ELSE... I think my BEGIN & ENDs are not right maybe?

CREATE PROCEDURE spLOGON

@ORGID int,

@USERNAME nvarchar(50),

@PWORD nvarchar(50)

AS

--record counter

DECLARE...