thanks very much guys, i will give this a try.

Thanks Vladan. I'm going to have to do some research because that makes it confusing. I don' see how Access will know what to place in the DB if it...

Thanks!  So do i create the same DB structure in both Access and SQL Server as usual with normalization?

This is all i think i need to know other than the info you...

thanks guys!

Thanks man!

Thanks very much for your help.  I've decided to take it a little further and create a Supervisors Table

SUPERVISORS

- SupervisorID

- EmpID

- Password

- DateBegan  - Date employee became supervisor

- DateEnded  - Date...

GREAT AMOUNT OF THANKS!

Thanks man! Its going to be the weekend before I get to test it out. I know nothing about networking. it was the one thing my school taught only sporadically....

"(assuming KMSServer is the name of the other machine) If it doesn't, there's a number of things that may be wrong, eg server protocol settings, allowing network connections to the server, even...

Thanks for your replies and explanations. They are very helpful.

Guys, a lot of times when i post to this site, i lose my posts. It happens often.  I...

is there a way to change the datatype without recreating the whole table or database? 

I tried changing it in Enterprise manager but could not find a way.

I think it is a decent article at least for newbies. I had no naming convention and haven't had time to develop one as i work on this project. Having...

Thanks!  That is good info from both of you.  I think it might be best for me to learn how to add the permissions from one role to anohter and...

Well, it is temporary even though i don't want delete. 

Can you assign the permissions of one role to another role?

Thanks guys!

Sorry, when i clicke edit post, i don't see anything that allows me to delete the thread.

I see, it works for the following posts but not the starting post.