Thank you. It read as if the user configures that themselves as to  where the logging is done. But if it's done automatically that is fine with me.

Thanks for help!

Juanita

HI. I can see where you set what type of loggins you log and how to view the sql logs but the documentation talks about setting somewhere in sql server where...

HI.. I did get to try both methods and it does give me the information I need. Thanks so much..!!!

Juanita

THANKS.. i'll look at my output again and try the diagram method also !!

HI. I tried sp_help and I don't seem to locate anything about relationships. Am I  reading the output incorrectly?

Thank you for the ideas !!! I will pass these along !!

Juanita

Thank you everybody.. I'm going to try these different options !!!

Juanita

I used the DTS wizard to do the import. Yes i did link the sql tables into the access database and yes the tables do show up as dbo_tablename

juanita

access 2000. i will add the user to the db owner role.

Yes, the owner is DBO. Are you saying that the access application would need to be modified?

juanita

THANK YOU SO MUCH !!!! IT WORKS PERFECTLY !!! 

HI. Can i install MDSE on my computer even though i have enterprise manager installed just so i can see what this msde looks like?

juanita

Thanks so much for the information !!! very important info !!

Juanita

Thanks !!!!

Thanks, I'll try that!