is this via enterprise manager, query analyser etc?

if so (and i'm assuming that the server IP address hasn't changed, protocols haven't been disbled and that ther are no problems with...

Thanks for your help on that one -

i had planned to paste these as stored procedures, but for the purposes of development i've used sql until the customer approves...

thats exctly what i was looking for (if Not Page.IsPostback Then)

you are correct on all counts, it is visual studio 2003 (i'm usually a c++/vb developer, so asp.net has a...

ok, below is the page load sub.

I think the problem is that the dataset is filled on page, load, which is overwriting any changes when the page is posted.

i've...

if you remove the database name from the ODBC connection string or ODBC settings then set the default database for those logins to be SDE1, sDE2 etc -

those users...

so we're all agreed - there isn't a good reporting solution that does it all and is cheap/easy to deploy

hint hint microsoft - there appears to be a gap...

just a though here, (and please feel free to contradict me)

it might be a quick and easy performance upgrade to ensure your t-log files and data files are on seperate...

maybe if "out for justice" could post us some info about his setup we could be a little more specific about what may be the easiest way to squeeze some...

Bills right there -

crystal is so buggy (or was) that access 2000 was always better for a report generator than crystal could ever be

but still give reporting services a try...

Chris,

my apologies - i didn't word it very clearly

what i actually meant was that range partitioning and snapsot isolation "should" in theory be transparent to your application code and...

i'm not sure why you're in such a mood scking, but basically i was saying

choose a solution that meets the scale of the problem

i agree with some of your...

more than likely your performance boost will come if you are running into locking issues where the new snapshot isolation issue may be of assistance.

also large tables and indexes can...

if you're looking for reasons not to use access then i can think of about a million.

aside from the obvious

security

performance

support requriements (have you seend how many times mdb files...

i think we've all got this wrong,

it's not the query thats missing, but an answer from the list of answers

the question should read

Assume that the column and table names...

I think it's designed to test ESP and psychic ability!!!!!