that is necessary as a person who knows answer to my question may not login the proper forum

he may not see my question, to increase the chance of getting the...

Remi iam using 3rd party hosting, like i had purchased a hosting pack from the webhosting companies, so msde is not a solution

true, but ms-acces is ideal for small buisness people.

sql-server is too costly u can go and check the rates, as the datasize grows they charge per mb, tht will make...

iam using msaccess 2002, a couple of million record is more than enough for me

my estimate is around 300,000 to 500,000 per table

some tables will hold very less data as they...

db goes offline means exactly what happens

becoz cost also a factor, cannot do webhosting using sql-server, it would be too costly

iam looking for mysql. its free!

but for the time being iam calculating about ms-access

i have not tested your query, becoz iam at different location dont have databse to check

iam talking about my query

suppose a candidates registers, his registration details will be stored in...

iam sorry, that u had to take so much efforts to solve my query..

thanks a lot, but you guessed it right, i will try your query, as i am not...

nope it doesn't work,

the query i posted doesn't work

select fname from candidatesmst

where candiid not in(select candiid from resumelist)

 i copied same schema in sql-server as well, but it doesn't return any...

what do you mean, down??, my site was never down, if it was down please tell me the time

are you people making joke of my question or what is it??

dear friends my query is too simple, but iam not getting any results,

if a candidate does not upload any...

well iam asking is very simple but it doesnt seems to work with me

both tables have "candiid" as coommon key

a candidates registration details are stored in

candidatemst table

and he can...

Words were written considering search engines not english, most indians understand that english, that is for indian people to post c.v

ya there were some typos,most were fixed, becoz my keyboard...

Lol, thats cool, even if some 1 manages to get in, he will always be able to damage only userid, so no real damage, and i was so worried about...

thanks a lot i will try this tool, if any of you have any other suggestions pls post