thanks for the prompt reply, but the app is about to go into UAT and I dont really want to have to explain to the IT guys that anyone wanting...

ok, that seems to be fixed now.

just for the benefit of anyone who finds this in the future, the problem was actually resolved by either of the following ;

1 a reboot...

funny how bean counters change their tune when they hear the magic word 'recruitment'.

i love the idea of having someone administer an entire complex system who doesnt understand it in...

in the temp table, define with an identity id field.

insert into the other fields, then use the identity to sort on.

dan

i had a similar situation once when we got involved with german auditors.  basically, tech ppl had to hands off the production server.  it is unworkable in my opinion.

we insisted...

i might be being a little fick here, but have you tried just restoring your database to the server ?

does sql not link up your new database automatically when you...

def use dts !  however, you will need to create the indexes yourself.

you can do it from access if you need to.

create a shell database with an autoexec macro that...

hey deek

it sounds like you have tried some different workarounds, but i did precisely the same type of query tool for users and it worked ok - not lightning, but...