One more question. If i'm using windows authentication mode, do i have to worry about password protecting the SA account?

Thanks guys! That basically answered my question.

It doesn't use the terms Windows Authentication Mode or Mixed Mode but i assume that SQL Server and Windows is Mixed...

thanks guys! i figured out that Access requires parathesis in the query while it is not necessary for the old ANSI-89 standard it appears to be necessary for its ANSI-92...

Thanks guys. I figured it out. Part of the problem was trying to build the queries from Design view and then changing them. But when i found the SQL view...

Thanks for the information. I will look up some info  on triggers!

Most of the books I've read says 5 also. I've heard that Access 2000 may accept about 25 simultaneous users.

Thanks guys. Buying  SQL Server 2000 won't be a big problem because we are a non Profit Org. I will look into MSDE but I wonder if we should limit ourselves...

Thanks guys!

The DB will have 10 to 15 tables at the most if that much. We only have about 200 employees so with in a year we may only...

Is The Guru's Guide to Transact-SQL for beginners or should i read BOL?  I've not looked at it yet but if that is all i need then i will start...

Thanks ALOT Erik! that is quite reassuring! It helps me to have a much more optimistic outlook. It is good hearing from people who were where you are and that...

Thanks guys. that was very informative!!!

Thanks guys! There were no political restrictions whatsoever.

Thanks very much!

thanks very much rock moose!!!!!

I appreciate your help!

What do you mean about "access method"? I know that JET is an engine.